Solved

oracle change password for user

Posted on 2011-02-18
5
611 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
make null the repeated levels 2 48
Sybase and replication server 13 80
Oracle - BLOB Extract Line 2 13
Age Calculation from specific date 19 57
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

734 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