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

Thread: Create a User

Hybrid View

  1. 01-21-2002, 03:31 PM #1
    gustavo
    gustavo is offline Junior Member
    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 ??
    Reply With Quote Reply With Quote
  2. 01-21-2002, 04:03 PM #2
    svk
    svk is offline Advisor
    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
    Reply With Quote Reply With Quote
  3. 01-21-2002, 04:09 PM #3
    gustavo
    gustavo is offline Junior Member
    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
    Reply With Quote Reply With Quote
  4. 01-22-2002, 02:09 AM #4
    julian
    julian is offline Senior Advisor
    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.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width