Re: Revoke CREATE LIBRARY or CREATE ANY LIBRARY

Hi,
I hope this can help you..

------------------------------Roles granted to user------------

select granted_role from dba_role_privs where grantee='OWNER';

------------------------------Owner privileges-----------------

select PRIVILEGE,GRANTEE from dba_sys_privs where grantee='owner';

--------------------------Privileges on table------------------------

select PRIVILEGE,owner,table_name
from dba_tab_privs where grantee='Owner';

bye Orietta

Demetris wrote:
> 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
Received on Tue Aug 19 2003 - 07:46:55 CDT