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

Report message to a moderator

Re: Alter username [message #160450 is a reply to message #160421] Sun, 26 February 2006 06:18 Go to previous message
Littlefoot
Messages: 21826
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

Report message to a moderator

Previous Topic: Enable Drop
Next Topic: how to demobld in windows environment for a new user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 16 12:57:43 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.