Re: Which user has which privileges

dba_role_privs gives you the roles
dba_sys_privs gives you the system privileges
dba_tab_privs gives you the object privileges
dba_col_privs gives you the privileges on the columns

There is no easy way because a user may have a privilege thru a role of a role of... but it can be done with SQL and connect by clause.

--
Have a nice day
Michel


Rene Nyffenegger <renenyffenegger_at_my-deja.com> a écrit dans le message :
8mn9br$mte$1_at_nnrp1.deja.com...


> Hi

>

> Is there an easy way to determine which user has which privileges?

>

> TIA

> Rene

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.