Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to show what has been granted
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