This statement can help you :

select owner,table_name,grantee,privilege from dba_tab_privs
where grantee in (select username from dba_users );

display all privileges for all users so as the grantor, if you want a
specific user and a specific grantor just add :


AND GRANTEE LIKE 'user1'
AND OWNER LIKE 'user2';

hope this help,


Bosco
Oracle DBA - Bellsouth

-----Original Message-----
From: Cal
[mailto:oracledba-ezmlmshield-x11002801.[Email address protected]
Sent: Wednesday, July 21, 2004 5:13 PM
To: LazyDBA Discussion
Subject: List User Privileges


Hello,

On an Oracle 8.17 system I need to list all the
privileges for a user so as I can duplicate some of
them for another user.

How can I do this from SQLPlus?


Thanks,

Cal




__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page