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: users and their privileges

Re: users and their privileges

From: Joe Philip <joephilip2002_at_comcast.net>
Date: Mon, 29 Jul 2002 21:49:54 GMT
Message-ID: <6Mi19.383144$Im2.19905771@bin2.nnrp.aus1.giganews.com>


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

Original text of this message

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