| DBMS_SQL. to create user.. [message #369962] |
Tue, 21 November 2000 02:10 |
Tarun Chhichhia
Messages: 6
Registered: November 2000
|
Junior Member |
|
|
Hi,
I am using Dynamic SQL to create user based on the username and access level passed to the procedure.
I am doing this in a Package called user_maintenance, via a procedure create_user.
When I run the dynamic SQL as a part of a PL/SQL anonymous block , it works fine and creates a user as desired.
When I run the same through the Package, which compiles without any errors, create_user DBMS_SQL fails with the following error :
ORA-01031: insufficient privileges.
I am running everything in the system user, so has all possible access you can think of..
Any help appreciated..
Thanks
Tarun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
