Re: Listing User Privileges

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 21 Jul 2004 22:26:11 -0700
Message-ID: <1090473995.930742@yasure>

Sybrand Bakker wrote:

> On 21 Jul 2004 16:13:57 -0700, melliott42_at_yahoo.com (Michael) wrote:
> 
> 

>>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 (I cannot use the OEM in this
>>environment)?
>>
>>
>>Thanks,
>>
>>Michael

> 
> 
> Check out dba_tab_privs, dba_role_privs, dba_sys_privs
> 
> 
> --
> Sybrand Bakker, Senior Oracle DBA

And, in addition:

dba_col_privs
dba_col_privs_made
dba_col_privs_recd
dba_tab_privs_made
dba_tab_privs_recd

session_privs
system_privilege_map

Daniel Morgan Received on Thu Jul 22 2004 - 00:26:11 CDT