dba_sys_privs and dba_tab_privs

Use role and just assign role to other users

-----Original Message-----
From: Cal
[mailto:oracledba-ezmlmshield-x11002801.[Email address protected]
Sent: Wednesday, July 21, 2004 7: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