-
I would like to create a user exacly like another one, with same access, grants and password. How could I solve this problem quickly ??
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|