Home » RDBMS Server » Security » Alter username
Alter username [message #160421] Sat, 25 February 2006 07:20 Go to next message
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
Senior Member
Can anybody tell how to change a username, like Scott to James
Re: Alter username [message #160450 is a reply to message #160421] Sun, 26 February 2006 06:18 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This will require several steps:
1. export current schema (Scott's)
2. create a new user (James)
3. import scott.dmp into James
4. drop user Scott
Previous Topic: Enable Drop
Next Topic: how to demobld in windows environment for a new user
Goto Forum:
  


Current Time: Thu Mar 28 07:27:28 CDT 2024