Re: Quick question for DBA

1. grant create public synonym to X; 2. select * from dba_sys_privs where privilege='CREATE PUBLIC SYNONYM'; and for each role u get, see what user got priv for this role: select * from dba_role_prives where granted_role='rolesfromselect'; (make from those 2 selects one select, i'm too lazy to do it now...:) )
2. look at table dba_role_privs.

--
Asaf Shoval
Oracle Israel Support Center

Norazman Abu Sahir <norazman_at_ti.com> wrote in message news:38017E7B.B8DB7A49_at_ti.com...
> Hi,
> 1) What privilege do I need to create a public synonym.
> 2) Other than SYSTEM user, how can I now who else can grant that
> privilege.
> 3) Is there an easy way I can see what privilege that a particular user
> currently hold.
>
> Thanks for sharing
>
> AzMaN
>
>
Received on Mon Oct 11 1999 - 10:21:37 CDT