Home » SQL & PL/SQL » SQL & PL/SQL » how to change the password for particular user in sql
how to change the password for particular user in sql [message #187115] Thu, 10 August 2006 23:02 Go to next message
youthsen
Messages: 45
Registered: August 2006
Member
hi pals

pls help me.

thanks a lot in advance.
Re: how to change the password for particular user in sql [message #187130 is a reply to message #187115] Fri, 11 August 2006 01:06 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See http://www.orafaq.com/faq/security
Re: how to change the password for particular user in sql [message #187213 is a reply to message #187115] Fri, 11 August 2006 05:59 Go to previous messageGo to next message
pamrajrajeev
Messages: 9
Registered: July 2006
Junior Member
Hey,


To change the password, u should have sufficient priviliges or better work in administrator mode(system/manager) and issue

alter user username identified by password;


For ex, assume their is a user by name raj with password raj123, now to change the password of said user, issue

ALTER USER RAJ IDENTIFIED BY ANU45;



Regards



Rajeev
Re: how to change the password for particular user in sql [message #187269 is a reply to message #187213] Fri, 11 August 2006 09:54 Go to previous messageGo to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
If you are the user and not an administrator, then you will not have privilege to use alter user command.

Simply issue "password" command at SQL prompt.

Ex:

sqlplus user01/test123

SQL*Plus: Release 10.1.0.4.0 - Production on Fri Aug 11 10:52:54 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning and Data Mining options

SQL>password
Changing password for user01
Old password:test123
New Password: testxyz
Password changed successfully.
SQL>

Re: how to change the password for particular user in sql [message #187290 is a reply to message #187269] Fri, 11 August 2006 12:54 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
raviganti wrote on Fri, 11 August 2006 09:54

If you are the user and not an administrator, then you will not have privilege to use alter user command.



Not totally correct, you can still use the alter, but only for yourself. However, in oracle 9 and above the password command is preferred, it allows the administrator to attach advanced password validation.
Re: how to change the password for particular user in sql [message #187301 is a reply to message #187290] Fri, 11 August 2006 14:14 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Beginning with 9iR2, users don't need the ALTER USER privilege in order to modify their own password with the ALTER USER syntax and have the password verify function included.

[Updated on: Fri, 11 August 2006 14:31]

Report message to a moderator

Re: how to change the password for particular user in sql [message #187323 is a reply to message #187115] Sat, 12 August 2006 02:45 Go to previous message
youthsen
Messages: 45
Registered: August 2006
Member
hi pals

thanks a lot for your valuable responses.
Previous Topic: string converstion
Next Topic: how to view all created users of sql (oracle).
Goto Forum:
  


Current Time: Wed Dec 07 14:19:46 CST 2016

Total time taken to generate the page: 0.05754 seconds