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 .


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


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