how to create alias user

Dears!!

i need to create an user including all objects from an existing user?
hwo can i do that?

thanks in advance!!

Hi,

I am not very sure but I can think of two different ways it can be done.

One is create the new user, export the old user with all its objects and import it into the new user. But if I am right you will have to physically assign roles and privileges alone.

The other method is to create a user like your original user using Oracle Security Manager. I have never done that before so I do not know more details on this. I remember seeing the option though!

Thanks,
-S