Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    34

    Unanswered: create table error

    Hi Friends,

    I'm trying to create a table with this command:

    execute immediate 'create table aaa .........' ;

    in a Package Body.

    I receive the following error:

    ORA-01031 Insufficient privileges

    (ORACLE 9i)

    What is the Problem?

    Thank you in advance!

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    Explicit grant

    Hi

    You'll need an EXCPLICIT grant for the create table privilege:

    SQL> GRANT CREATE TABLE TO <user_who_is_executing_procedure>

    Good luck

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Jan 2003
    Posts
    34

    Re: Explicit grant

    Originally posted by remivisser
    Hi

    You'll need an EXCPLICIT grant for the create table privilege:

    SQL> GRANT CREATE TABLE TO <user_who_is_executing_procedure>

    Good luck

    Remi


    ------------------------
    Many many tanks for you help to all my daily questions!

    Gratefully
    Pappagone

  4. #4
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    No worries!

    You are very welcome!!
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •