Dan:
This is not what I am looking for. I am looking for some scripts which pulls
information from the dba_roles and dba_sys_privs etc.
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D45A5E2.53C5994C_at_exesolutions.com...
> Joe Philip wrote:
>
> > Do anybody have a script to find the users and their privileges of a
> > database?
>
> No need for any script.
>
> Just perform the following:
>
> SELECT object_name
> FROM all_objects
> WHERE object_name LIKE '%PRIV%';
>
> Then do a describe on what you find and all of the information is
> available with just a SQL statement or two.
>
> Daniel Morgan
>
Received on Mon Jul 29 2002 - 16:49:54 CDT
