Re: Creating Oracle user based on an existing user

Hi

If you can get the O'Rielly book "Oracle scripts" there is a good set of scripts on there for copying users with the same set of roles, privileges as another user. Not sure if they are available on line or not

cheers

Pete Finnigan
www.pentest-limited.com

In article <f34d8e79.0108180151.79fa6750_at_posting.google.com>, T Kabilan <t.kabilan_at_blr.spcnl.co.in> writes
>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.

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com