Re: Revoke CREATE LIBRARY or CREATE ANY LIBRARY

> Hello people!
> I was wondering how can I find with an sql statement which user (there
> are a lot) has the above priviledges.
> O/S: AIX 5.1
> DB server: Oracle 8.1.7.4
>
> Thank you

Demetris,

I have a script on my homepage that can be used to show the hierarchical relationship between privileges, roles and users.

In your case, you need the second:
http://www.adp-gmbh.ch/ora/misc/recursively_list_privileges.html

Hth
Rene

-- 
  Rene Nyffenegger
  www.adp-gmbh.ch