Re: Two simple questions.

In article <2sj4bbF1k8r7qU1_at_uni-berlin.de>, Gama Franco wrote:
> Hello,
>
> 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?

Did you try? What happened?  

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

Look into dba_role_privs and dba_sys_privs and dba_tab_privs.

See also
http://www.adp-gmbh.ch/ora/misc/recursively_list_privilege.html on my homepage

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/