Re: Role's privileges

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/27
Message-ID: <39800E22.3F3B@yahoo.com>#1/1

Paul wrote:
>
> Hi,
> Could someone tell me the SQL command to know the object and system
> privileges for the role, such as CONNECT or roles created by me.
>
> Thanks
>
> Paul Li
>
> --
> Posted via CNET Help.com
> http://www.help.com/

dba_tab_privs
dba_role_privs
dba_sys_privs

should get you started...

Roles are actually owned by anyone...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Thu Jul 27 2000 - 00:00:00 CDT