Re: Two simple questions...

Comments embedded.

> 1 - Is it possible to run a stored procedure using the privileges
> granted to a user through a role? I mean, is there any way to do it?
 

Yes.

SQL> grant execute on <procedure> to <role>;
SQL> grant <role> to <user>;
SQL> connect <user>/<password>
SQL> execute <owner>.<procedure>;

>
> 2 - How do I inspect the roles of a user using SQL PLUS?

look up description of dba_users and dba_role_privs.

Regards
/Rauf Received on Thu Oct 07 2004 - 09:09:37 CDT