Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Two simple questions.

Re: Two simple questions.

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 6 Oct 2004 23:00:15 GMT
Message-ID: <slrncm8u01.3tk.rene.nyffenegger@zhnt60m34.netarchitects.com>


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/
Received on Wed Oct 06 2004 - 18:00:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US