Re: How to show what has been granted

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Fri, 11 Oct 2002 10:15:34 +0200
Message-ID: <ao61hm$j358o$1@ID-152732.news.dfncis.de>

<kennethkoenraadt_at_no-spam.hotmail.com> schrieb im Newsbeitrag news:3da67ed6.1288562_at_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

... which can be checked by the DDView ROLE_ROLE_PRIVS ... There You can trace the user defined roles back to predefined roles like DBA.
> 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.

... see above. Usually the data dictionary can tell everything you need. Jan Received on Fri Oct 11 2002 - 03:15:34 CDT