How to change oracle user password?
Tuesday, June 9, 2009
Question: How to change oracle user password?
Answer:
The syntax is:
alter user [user_name]
identified by [new_password] ;
user_name is the user whose password you wish to change.
new_password is the new password to assign.
For eg:I wanted to update system user password to helloworld
SQL> alter user system identified by helloworld;
User altered.
0 comments: to “ How to change oracle user password? ”
Post a Comment