Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    India
    Posts
    3

    Unanswered: Privileges reqd. to create table using dynamic sql in a prcedure

    what are Privileges reqd. to create tables dynamically in oracle using Execute immediate within a procedure. The procedure gets compiled successfully, but when i execute it i get an error insufficient privileges. Can someone help me.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Privileges reqd. to create table using dynamic sql in a prcedure

    The procedure owner must have been granted the CREATE TABLE privilege directly, not via a role. Role privileges are not applied in procedures.

  3. #3
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Procedure compiles succesfully because the statement submitted is not evaluated until run-time.

    JoeB

Posting Permissions

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