Re: Quick question for DBA

The above answers are right, but things can get a little more complicated. A user can have various rights granted directly, or through having roles. He'll also have those rights which have been granted to public. Since roles and privileges can be granted to other roles, you have to drill down to the bottom role to find out all the rights your user has. I've been writing a set of scripts for this recently, so email me in a month if you want a copy (real work takes priority).

Van

sysdba <sysdba_at_inter.net.il> wrote in message news:7tsurp$os3$1_at_news2.inter.net.il...
> 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...:) )
>
> 3. 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 - 18:42:38 CDT