Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Listing User Privileges

Re: Listing User Privileges

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 22 Jul 2004 06:39:43 +0200
Message-ID: <g7huf0di265n2dfd4lsql6j0d5aalp2id2@4ax.com> 





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


Received on Wed Jul 21 2004 - 23:39:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US