Create a User
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Create a User

  1. #1
    Join Date
    Dec 2001
    Posts
    6

    Question

    I would like to create a user exacly like another one, with same access, grants and password. How could I solve this problem quickly ??

  2. #2
    Join Date
    Jul 2000
    Posts
    521
    Use OEM (security).
    Select the user. Right click. Select "Create Like...".

    You may have problems if the original user has been granted privileges from other schema. So, see the generated SQL commands. Execute those 'failed' commands from proper user.
    svk

  3. #3
    Join Date
    Dec 2001
    Posts
    6
    Does someone know the SQL code to execute this command ? I need to run it directly in a tool like TOAD, or SQP Plus.
    Thanks in Advance

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    As far as I know there is no direct command to accomplish that. You have to do that through scripts if you do not want to use OEM.


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