Re: Quick question for DBA

Hi

1. The user needs the CREATE PUBLIC SYNONYM system privilege
2. If you can select user from dba_sys_privs where privilege ='CREATE PUBLIC SYNONYM' then the admin option will tell you. If your user can't see the dba_sys_privs view i.e. you have no rights to the view then i think you're stuck.
3. If logged on as the user - for roles select granted_role from user_role_privs, for system privs select off user_sys_privs. Note - user_sys_privs will only show explicit grants. Or if logged in as a DBA user select off dba_role_privs where user = USERNAME etc.

Hope it helps

Cameron

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 - 07:02:29 CDT