I would like to create a user exacly like another one, with same access, grants and password. How could I solve this problem quickly ??
Printable View
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.
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.