Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2003
    Posts
    129

    Unanswered: ORA-01031 and ORA-06512

    I have the following errors when i try to create a user via a procedure

    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
    ORA-06512: at "SYS.DBMS_SQL", line 32
    ORA-06512: at "TOM.P_NEW_USER", line 6
    ORA-06512: at line 1

    What does the above mean and how can i fix it?

    The line 6 points to DBMS_SQL.PARSE()

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: ORA-01031 and ORA-06512

    Originally posted by dominant
    I have the following errors when i try to create a user via a procedure

    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
    ORA-06512: at "SYS.DBMS_SQL", line 32
    ORA-06512: at "TOM.P_NEW_USER", line 6
    ORA-06512: at line 1

    What does the above mean and how can i fix it?

    The line 6 points to DBMS_SQL.PARSE()
    It seems the user "TOM" hasn't CREATE USER privilege, or the user need the DBA role. If there isn't problem then i have simple workaround:
    Create the procedure under user sys, grant to execute this procedure to TOM and then exucute it under TOM by SYS.P_NEW_USER (maybe you will need to use execute immediate clause)

  3. #3
    Join Date
    Jul 2003
    Posts
    129
    It seems that the grant create user to tom gave us a solution but now i cannot procceed because it says that the ROLE i set to the user doesn't exist

    Even though,i can see the ROLEs(through the enterprise manager) that my Application uses, it says that cannot find them.

    Any idea?

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by dominant
    It seems that the grant create user to tom gave us a solution but now i cannot procceed because it says that the ROLE i set to the user doesn't exist

    Even though,i can see the ROLEs(through the enterprise manager) that my Application uses, it says that cannot find them.

    Any idea?
    which version of oracle you are using?

  5. #5
    Join Date
    Jul 2003
    Posts
    129
    Oracle 9i R2

  6. #6
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by dominant
    Oracle 9i R2
    Could you post all grants for user TOM and for the new created user?

  7. #7
    Join Date
    Jul 2003
    Posts
    129
    I fixed the problem by deleting and recreating the role.

    Those new roles had been created during a full import (unsuccessful, The things that ware created, were the ROLE names )

    Now i recreated them and everything is ok.

    Thanks for you help!

Posting Permissions

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