Click here to Skip to main content
11,639,178 members (63,630 online)
Click here to Skip to main content

Tagged as

How to Change Password in Oracle

, 7 Feb 2011 CPOL 21.3K 2
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 .

You may also be interested in...

Comments and Discussions

Ken Row23-Aug-12 21:42
memberKen Row23-Aug-12 21: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
Web01 | 2.8.150728.1 | Last Updated 7 Feb 2011
Article Copyright 2011 by Kaveh Yazdi Nezhad
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid