Solved

oracle change password for user

Posted on 2011-02-18
5
550 Views
Last Modified: 2012-05-11
If i have a user name bill how do i change his password using sql
0
Comment
Question by:Brant Snow
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:sventhan
ID: 34930136
alter user bill identified by bill  --- bill is the password
0
 
LVL 18

Expert Comment

by:sventhan
ID: 34930144
if you want to expire the password after the first login....

alter user bill identified by yourpassword password expire
0
 
LVL 18

Accepted Solution

by:
sventhan earned 500 total points
ID: 34930154
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.

http://www.techonthenet.com/oracle/password.php
0
 
LVL 4

Author Comment

by:Brant Snow
ID: 34930294
alter user jeff identified by 83ios32S

i do that but i get a
SQL Error: ORA-00922: missing or invalid option
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

can a user alter their own password, in other words if i am logged in as jeff can i still alter my password as long as he has the correct priveledges
0
 
LVL 4

Author Comment

by:Brant Snow
ID: 34930315
never mind i just had a bad character in the password i made works great
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question