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 !!?

----------------------------------------------------------------------

Report message to a moderator

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';

----------------------------------------------------------------------

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 08:34:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.