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: How can I list all the privs of all Roles in an instance?

Re: How can I list all the privs of all Roles in an instance?

From: Myron Wintonyk <Myron.Wintonyk_at_UAlberta.ca>
Date: Mon, 2 Apr 2001 09:28:16 +1000
Message-ID: <9a8do3$6fp$1@kraken.itc.gu.edu.au>

select * from dba_tab_privs;
select * from dba_role_privs;
select * from dba_sys_privs;

"Ewin Barnett" <ewin_at_acm.org> wrote in message news:3AC755EA.644C7AFE_at_acm.org...
> see subject.
> --
> ====
> Ewin Barnett, Boone County, Missouri, USA.
>
> "Democracy and socialism have nothing in common but one word:
> equality. But notice the difference: while democracy seeks equality
> in liberty, socialism seeks equality in restraint and servitude."
> --Alexis De Tocqueville
Received on Sun Apr 01 2001 - 18:28:16 CDT

Original text of this message

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