OraFAQ Forum: SQL & PL/SQL » Re: Creating a user in a stored procedure

Home » SQL & PL/SQL » SQL & PL/SQL » Re: Creating a user in a stored procedure - compile error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Creating a user in a stored procedure - compile error [message #2565]

Fri, 26 July 2002 14:25

Mark Grimshaw
Messages: 73
Registered: June 2002

Member

Thanks Todd - although Oracle security rules are beginning to cause me a few headaches. For instance, what is confusing is that I can create a user from the SQL Plus command line but not through the Stored procedure even though the EXECUTE ANY PROCEDURE was given by SYS! So, is the rule that if any privilege is gained for a user (any user) through a Role then any privileges on objects needed within that procedure need to be granted explicitly ? If that is the case what is the point in having a Role ?

Report message to a moderator

Previous Topic:	Urgent – Fundamental – Primary key
Next Topic:	To Restricte User to Login in SQL*Plus.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 12:46:39 CDT 2024