Solved

oracle change password for user

Posted on 2011-02-18
5
577 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Retreiving column names in Windows but not in Unix 11 57
Help on model clause 5 37
migration MS SQL database to Oracle 30 68
oracle numeric condition check 4 27
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

808 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