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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
You do NOT change usernames.
to change password ALTER USER ELMER_FUDD IDENTIFIED BY NEW_PASSWORD

Report message to a moderator

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;

Report message to a moderator

Previous Topic: External data source
Next Topic: sqlplus error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:30:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.