Re: Creating Oracle user based on an existing user

Hi Kabilan,

1. Query the data dictionary to find all the object and system privileges directly granted to 'xyz'
2. Put these priviliges under a role MYROLE.
3. Revoke the object and system privileges granted directly to 'xyz'
4. Grant MYROLE to the new user.

This will solve the actual problem and (what's even better) get rid of the "grown with time" thing which undermines your system security.

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com

On 18 Aug 2001 02:51:32 -0700, t.kabilan_at_blr.spcnl.co.in (T Kabilan) wrote:

>Hello,
>
>We have an existing Oracle user 'xyz' with a set of permissions on a
>variety of tables (these permissions are unfortunately not present as
>roles and have grown with time).
>
>Can you suggest a script with which this can be done?
>
>Thanks for your valuable time.
>
>Best Regards,
>Kabilan.
Received on Sat Aug 18 2001 - 09:18:22 CDT