Home » RDBMS Server » Server Administration » Howto create a duplicate user.
Howto create a duplicate user. [message #169542] Thu, 27 April 2006 09:31 Go to next message
SweD
Messages: 3
Registered: April 2006
Junior Member
Hello,

for traceability purpose I need to create a new user.

The new user needs to be an identical copy of an already exsisting user, and all grants and privliges of the original user's schema should be the same. I.E the new user must be allowed to work on the original user's schema as if they were one and the same.

I guess it comes down to this: How does one grant full access to one user for the full schema of another user.
It would of course also be preferable if these grants are automatically applied to any future additions of data objects in the original schema.

Regards,
/Dennis

Re: Howto create a duplicate user. [message #169545 is a reply to message #169542] Thu, 27 April 2006 09:42 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please see whether this helps
http://www.orafaq.com/forum/m/120560/42800/?srch=cr_user_like#msg_120560
Previous Topic: Session
Next Topic: Log_archive_dest_n
Goto Forum:
  


Current Time: Fri Sep 20 14:25:20 CDT 2024