No, You cannot rename a database user directly. But if it is needed then you can take export of the user which has to be changed and create a new user with new name. Import the exported objects by using FROMUSER and TOUSER . Finally you can drop the pervious user.
Note: It is advisable to generate script for creating the new user from the existing user because you can have same values for all parameters and just replace the new user name with the old one. Use any reverse engineering tool for this. You can use SQL Navigator also.
|
