|
Re: Password Management [message #58050 is a reply to message #58047] |
Mon, 28 July 2003 17:24 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
You should make use of PASSWORD_VERIFY_FUNCTION.
login as sys.
create a profile with limit to custom function that uses a PASSWORD_VERIFY_FUNCTION.
assign this profile to the user.
once you assign this,
the user cannot change the password by alter user
or
by executing sqlplus command password.
to break the restriction
you should login as sys and revoke the profile from user.
[Updated on: Thu, 09 March 2006 06:09] Report message to a moderator
|
|
|
Re: Password Management [message #58064 is a reply to message #58050] |
Tue, 29 July 2003 06:43 |
C. Amarnath
Messages: 7 Registered: July 2003
|
Junior Member |
|
|
Hi,
Thanks for the response.
I have doubt in this workaround.
Password_verify_function is to be used for verify complexity of new passwords, but pls le me know how to use this function to restrict any user to change his own password.
Thanks in advance,
Amarnath
|
|
|
|
|
Re: Password Management [message #58068 is a reply to message #58066] |
Tue, 29 July 2003 08:58 |
C. Amarnath
Messages: 7 Registered: July 2003
|
Junior Member |
|
|
Mahesh,
I have followed all the steps and now noticed that a strange thing happened here.
Even when i login as user with dba privs also, i am unable to change the password for this user.
Pls help me now.
Amarnath
|
|
|
Re: Password Management [message #58069 is a reply to message #58068] |
Tue, 29 July 2003 09:07 |
C. Amarnath
Messages: 7 Registered: July 2003
|
Junior Member |
|
|
Mahesh,
I have followed all the steps and now noticed that a strange thing happened here.
Even when i login as user with dba privs also, i am unable to change the password for this user.
Pls help me now.
Amarnath
|
|
|
Mahesh, very urgent pls...Password Management [message #58070 is a reply to message #58069] |
Tue, 29 July 2003 09:09 |
C. Amarnath
Messages: 7 Registered: July 2003
|
Junior Member |
|
|
Mahesh,
I have followed all the steps and now noticed that a strange thing happened here.
Even when i login as user with dba privs also, i am unable to change the password for this user.
Pls help me now.
I have to change the pwd as DBA user.
Amarnath
|
|
|
|
|
|