From: "Michel Cadot" <micadot@netcourrier.com>
Subject: Re: Which user has which privileges
Date: 2000/08/08
Message-ID: <8modj3$t0i$1@s1.read.news.oleane.net>#1/1
References: <8mn9br$mte$1@nnrp1.deja.com>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@oleane.net
X-Trace: s1.read.news.oleane.net 965720483 29714 195.101.229.231 (8 Aug 2000 07:41:23 GMT)
Organization: Guest of France Telecom Oleane's newsreading service
Reply-To: "Michel Cadot" <micadot@netcourrier.com>
NNTP-Posting-Date: Tue, 8 Aug 2000 07:41:23 +0000 (UTC)
Newsgroups: comp.databases.oracle.misc


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@my-deja.com> a écrit dans le message :
8mn9br$mte$1@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.