Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

oracle change password for user

Posted on 2011-02-18
5
Medium Priority
?
766 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

577 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