Home » SQL & PL/SQL » SQL & PL/SQL » Re: Creating a user in a stored procedure - compile error
Re: Creating a user in a stored procedure - compile error [message #2561] Fri, 26 July 2002 10:29
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
SYSTEM only has the CREATE USER privilege through the DBA role, so if this procedure will be owned by SYSTEM, it will need a direct grant to CREATE USER given by SYS.

Report message to a moderator

Previous Topic: serial number in select statement
Next Topic: fetching the previous sum and current sum
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 16:46:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.