Howto create a duplicate user. [message #169542] |
Thu, 27 April 2006 09:31 |
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
|
|
|
|