Click here to Skip to main content
Click here to Skip to main content

Tagged as

How to Change Password in Oracle

, 7 Feb 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
there are different ways to change password of roles in oracle
If you are going to change password of a role in oracle , there are two possible ways:
 
A- for none built in roles (sys,system) :
1- connect to oracle with sql plus or any other client tool
2- type :
password ;
3- old password will be asked first and after that you have to enter new password and its confirmation.
4- oracle will change the password ...
 
B- if you wante to change sys/system password , you have to work a little more :
1- connect to oracle
2- run this command :
 alter user sys/system  identified by newpassword;
3- restart your oracle service or your O.S
 
C- You can use Update command :
update sys.user$ set password='Newpass' where name='SCOTT';
 
it's needed to mention that sys/system passwords will change after system/service restart and before that still you can connect with old passwords .

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Kaveh Yazdi Nezhad
Software Developer
Canada Canada
I'm a computer programmer Have worked within the information technology companies for over 10 years.
 
Object oriented programming, N-Tire architecture, SQL and Oracle stored procedures, HR, Accounting, Banking, Smart card programming, optimizing SQL queries and database structure and also training end-users are some of my experiences .
Follow on   LinkedIn

Comments and Discussions

 
GeneralDO NOT UPDATE SYS.USER$ PinmemberKen Row23-Aug-12 22:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.1411019.1 | Last Updated 7 Feb 2011
Article Copyright 2011 by Kaveh Yazdi Nezhad
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid