Re: Need to generate a report showing all users and what objects they have access to???

On Fri, 20 Feb 2004 12:42:43 -0000, "Noel" <tbal_at_go2.pl> wrote:

>Instead of sending you to online docs, here is the 'secret' :
>
>SELECT GRANTEE, OWNER, TABLE_NAME, PRIVILEGE, GRANTOR
> FROM DBA_TAB_PRIVS
>ORDER BY GRANTEE, TABLE_NAME, PRIVILEGE;
>--
>Noel

And evidently the answer is incorrect, because: it doesn't show the privilege granted to the user only, and it doesn't show the privileges granted to the user by means of a role.
The Finnigan script however was complete.

--
Sybrand Bakker, Senior Oracle DBA