Home » RDBMS Server » Security » change password
change password [message #153858] Wed, 04 January 2006 07:53 Go to next message
matrik02
Messages: 64
Registered: November 2005
Member
I am still new in Oracle 9i .I have create the user account and password.Now i want to know,Does User can change the password?What the special priviledge i need to set for the user i have already create so that i want to prevent the user to change the password i have set for them... Hope some one can give an idea

Thanks
Re: change password [message #154283 is a reply to message #153858] Fri, 06 January 2006 10:25 Go to previous messageGo to next message
DanielRey
Messages: 11
Registered: January 2006
Location: Mendoza, Argentina
Junior Member
Hello matrik02.

Yeah, there is a way to prevent the user to change their own password.

First, you must create this function as SYS:
CREATE OR REPLACE FUNCTION "SYS"."VERIFY_FUNCTION_FIX_PWD"
(username VARCHAR2,
password VARCHAR2, old_password VARCHAR2) RETURN boolean IS
BEGIN
raise_application_error(-20009, 'SORRY, PASSWORD CANNOT BE CHANGED') ;
END ;

Second, you must create an profile, or assign this function to an existent one:
ALTER PROFILE "SECURE_PASS" LIMIT PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_FIX_PWD;

Third, you must assign this profile to taht user:
ALTER USER "USER_NAME" PROFILE "SECURE_PASS";

That's all folks.

Regards
Daniel
Re: change password [message #156860 is a reply to message #153858] Sat, 28 January 2006 18:13 Go to previous message
Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay
Member
matrik02 wrote on Wed, 04 January 2006 07:53

i want to prevent the user to change the password i have set for them... Hope some one can give an idea


Why would you do that ?
Previous Topic: Detecting Computer Hardware Serials Using Oracle
Next Topic: 1 user with 2 authentiations
Goto Forum:
  


Current Time: Thu Mar 28 09:05:01 CDT 2024