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: Gama Franco <tiago_at_cern.ch>
Date: Thu, 07 Oct 2004 01:34:32 +0100
Message-ID: <2sjh8qF1ljaqpU1@uni-berlin.de>


Rene Nyffenegger wrote:
> 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?

By default Stored Procedures use the previleges granted directly to the user. I'm having a problem on a stored procedure that creates a database link for this reason.
>
>
>>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.
thanks.
>
> See also
> http://www.adp-gmbh.ch/ora/misc/recursively_list_privilege.html
> on my homepage
>
> hth
> Rene
>

Best regards,

   Gama Franco Received on Wed Oct 06 2004 - 19:34:32 CDT

Original text of this message

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