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: Geoffroy Braem <geoffroy.braem_at_logidox-computing.com>
Date: Fri, 23 Jul 2004 02:40:06 +0200
Message-ID: <41005E66.7010601@logidox-computing.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
>
>

If you have to repeat this you'd better use roles instead of granting system privileges to individual users.

-- 

geoffroy.braem_at_logidox-computing.com
CM (Clearcase) & DataWarehouse(Oracle) consulting, Unix programming (Java, Perl, Korn Shell).
in Belgium, England, Luxembourg and more.
www.logidox-computing.com
Received on Thu Jul 22 2004 - 19:40:06 CDT

Original text of this message

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