Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Listing User Privileges
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.comReceived on Thu Jul 22 2004 - 19:40:06 CDT