Home » SQL & PL/SQL » SQL & PL/SQL » Insufficient privileges !?
Insufficient privileges !? [message #35796] Tue, 16 October 2001 08:42 Go to next message
André V. B.
Messages: 3
Registered: October 2001
Junior Member
I am with a problem in procedure in the hour of the execution in determined command " CREATE ROLE ROLE_NOVOS_USUARIOS NOT IDENTIFIED "
I occur the following error: "Insufficient privileges", but if I to execute direct the command it creates Role normally !!?

----------------------------------------------------------------------
Re: Insufficient privileges !? [message #35798 is a reply to message #35796] Tue, 16 October 2001 09:00 Go to previous message
Sam
Messages: 255
Registered: April 2000
Senior Member
If in Oracle 8 try:
EXECUTE IMMEDIATE 'CREATE ROLE ROLE_NOVOS_USUARIOS';

----------------------------------------------------------------------
Previous Topic: PLS-00103: Found symbol " CREATE ", HELP !!!!!!!!
Next Topic: Table Lock
Goto Forum:
  


Current Time: Sat May 25 03:42:14 CDT 2024