how to create alias user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to create alias user

  1. #1
    Join Date
    Sep 2001
    Location
    Jurong East/Singapore
    Posts
    70

    Thumbs up

    Dears!!

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

    thanks in advance!!

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width