Re: Quick question for DBA

Hello

> 1) What privilege do I need to create a public synonym.
CREATE SYNONYM ie.e GRANT CREATE SYNONYM TO username;

> 2) Other than SYSTEM user, how can I now who else can grant that
> privilege.

Two ways:

GRANT CREATE SYNONYM TO username with GRANT OPTION

This user can now grant CRAETE SYNONYM to another user.

I also think there is a general privilage.. Like GRANT ANY PRIVILAGE
GRANT ANY ROLE
> 3) Is there an easy way I can see what privilege that a particular
user
> currently hold.

Yep. Queries the views...
DBA_TAB_PRIVS
DBA_COL_PRIVS DBA_SYS_PRIVS EG..
Return all object privs for a user:

1. select * from DBA_TAB_PRIVS where grantee='SCOTT';
2. select * from DBA_SYS_PRIVS where grantee='SCOTT';

You need to be SYS or SYSTEM to query these views.

Cheers!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 11 1999 - 02:49:00 CDT