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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to show what has been granted

Re: How to show what has been granted

From: <kennethkoenraadt_at_no-spam.hotmail.com>
Date: Fri, 11 Oct 2002 07:37:12 GMT
Message-ID: <3da67ed6.1288562@news.mobilixnet.dk>


Hi Ted,

Just a warning : That is not enough.

It does not count in the privileges given to the user through roles.

AND roles granted to roles granted to roles which are then granted to the user.....privileges can this way be buried very deeply in the role hierarchy.

Solution : Find a tool that can dig trough the hierarchy or write a recursive PL/SQL package that can do the job.

On Thu, 10 Oct 2002 14:48:32 -0600, "Ted" <root_at_aol.com> wrote:

>thankS!!!
>
>
>"David Sharples" <david.sharples3_at_ntlworld.com> wrote in message
>news:UAlp9.1598$4r1.27390_at_newsfep3-gui.server.ntli.net...
>> look in user_sys_privs or dba_sys_privs
Received on Fri Oct 11 2002 - 02:37:12 CDT

Original text of this message

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