Home » RDBMS Server » Server Administration » How to change the usernames and passwords
How to change the usernames and passwords [message #194337] Thu, 21 September 2006 10:06 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

How to change the username,passwords of existing schemas.


Thanks


Re: How to change the usernames and passwords [message #194341 is a reply to message #194337] Thu, 21 September 2006 10:22 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You do NOT change usernames.
to change password ALTER USER ELMER_FUDD IDENTIFIED BY NEW_PASSWORD
Re: How to change the usernames and passwords [message #194342 is a reply to message #194337] Thu, 21 September 2006 10:24 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
There is no ways to rename a user.You have to create another user of ur choice and you can copy objects from old to new.then drop old user with cascade option;
Previous Topic: External data source
Next Topic: sqlplus error
Goto Forum:
  


Current Time: Sat Dec 10 05:22:31 CST 2016

Total time taken to generate the page: 0.21509 seconds