Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2002
    Location
    Belgium
    Posts
    6

    Unanswered: Create table : insufficient privileges error.

    when issuing a Create Table command from within a dynamic cursor in PL/SQL I get an error : 'ORA-01031: insufficient privileges'. The PL/SQL procedure was called in SQL*Plus, logged in as a user that can create tables.
    Any idea ?

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

    Re: Create table : insufficient privileges error.

    Originally posted by dirkvdo
    when issuing a Create Table command from within a dynamic cursor in PL/SQL I get an error : 'ORA-01031: insufficient privileges'. The PL/SQL procedure was called in SQL*Plus, logged in as a user that can create tables.
    Any idea ?
    Your user has a ROLE that can create tables, but has not been granted CREATE TABLE privilege directly. Dynamic SQL doesn't look at the ROLE, only the user.

  3. #3
    Join Date
    Jun 2002
    Location
    Belgium
    Posts
    6

    Role vs Privileges

    Thanks, but, how do I assign privileges to the PL/SQL user directly (not using a role) ?

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

    Re: Role vs Privileges

    Originally posted by dirkvdo
    Thanks, but, how do I assign privileges to the PL/SQL user directly (not using a role) ?
    GRANT CREATE TABLE TO username;

  5. #5
    Join Date
    Jun 2002
    Location
    Belgium
    Posts
    6

    Thanks.

    First I forgot how to read a manual (just post a question to the appropriate forum),
    Now I seem to have forgotten how to think !

    Sorry. But thanks anyway.

  6. #6
    Join Date
    Jul 2004
    Posts
    3

    Thank you

    what you talk clears the way for me, thanks

Posting Permissions

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