|
Re: Enforce password change on first login [message #130693 is a reply to message #130675] |
Tue, 02 August 2005 00:28 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
U can achieve it by creating a user with expired passwords.
SQL> create user kart1 identified by forgotpwd
2 password expire;
User created.
SQL> grant connect,resource to kart1;
Grant succeeded.
SQL> conn kart1/forgotpwd;
ERROR:
ORA-28001: the password has expired
Changing password for kart1
New password: *****
Retype new password: *****
Password changed
Connected.
And if u want that the user should not use the old password again then u can assign profiles to the user as per ur requirement.
regards,
tarun
|
|
|
Re: Enforce password change on first login [message #130699 is a reply to message #130675] |
Tue, 02 August 2005 01:05 |
rebeccaz
Messages: 18 Registered: August 2005
|
Junior Member |
|
|
Hi,
I have tried as follow but was given the following error. Kindly advise. Thank you.
SQL> create user jean identified by forgotpwd password expire;
User created.
SQL> grant connect, resource to jean
2 ;
Grant succeeded.
SQL> conn jean/forgotpwd;
ERROR:
ORA-01017: invalid username/password; logon denied
Regards,
Rebecca
|
|
|
Re: Enforce password change on first login [message #130700 is a reply to message #130699] |
Tue, 02 August 2005 01:14 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
Hi,
It should not display an error cos the command is perfectly correct. The problem is that ur new user is not able to login.
>>>> SQL> conn jean/forgotpwd;
ERROR:
ORA-01017: invalid username/password; logon denied
Are u using hoststring to connect to the database ?
Eg. conn jean/forgotpwd@testdb
or try one thing create a normal user and try to login from that user.
Jst try this
SQL> create user jean identified by forgotpwd ;
User created.
SQL> grant connect, resource to jean
2 ;
Grant succeeded.
SQL> conn jean/forgotpwd;
and check r u able to connect?
regards,
tarun
|
|
|
|
Re: Enforce password change on first login [message #130705 is a reply to message #130702] |
Tue, 02 August 2005 01:46 |
rebeccaz
Messages: 18 Registered: August 2005
|
Junior Member |
|
|
Hi,
I did the following, for an existing user, rebecca. However, I realized that this prompts for password expires only prompts at the backend but not at the application level. Pls advise.
alter user rebecca identified by password4 password expire;
|
|
|
Re: Enforce password change on first login [message #130706 is a reply to message #130702] |
Tue, 02 August 2005 01:47 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
It's not a big deal but u have to perform in a different way.
Run this command for every user.
SQL> ALTER USER KART1
2 PASSWORD EXPIRE;
User altered.
SQL> CONN KART1/KART2
ERROR:
ORA-28001: the password has expired
Changing password for KART1
New password: *****
Retype new password: *****
Password changed
Connected.
SQL>
regards,
tarun
|
|
|
Re: Enforce password change on first login [message #130708 is a reply to message #130705] |
Tue, 02 August 2005 01:51 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
rebeccaz wrote on Tue, 02 August 2005 12:16 | Hi,
I did the following, for an existing user, rebecca. However, I realized that this prompts for password expires only prompts at the backend but not at the application level. Pls advise.
alter user rebecca identified by password4 password expire;
|
Rebaccaz,
Now pls post the exact scenario with Frontend and Backend mentioned with versions. Also ur requirements in that.
regards,
tarun
|
|
|
Re: Enforce password change on first login [message #130722 is a reply to message #130708] |
Tue, 02 August 2005 02:30 |
rebeccaz
Messages: 18 Registered: August 2005
|
Junior Member |
|
|
Hi,
I am using MAXIMO 5.2, a software application at the front end and using Oracle database 9i, standard edition. I am required to prompt users to change their password when they first login in to the application not to database. However, MAXIMO does not provides function to do that. Hence, I thought of enforcing this at the backend.
Regards,
Rebecca
|
|
|
Re: Enforce password change on first login [message #130724 is a reply to message #130722] |
Tue, 02 August 2005 02:39 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
Hi Rebecca,
Sorry i never used MAXIMO 5.2 . I m a DBA and new in this field but a thought strikes my mind.
Cant u achieve ur requirement by making some coding changes in the frontend s/w .
See whenever a new/old user is prompted at the backend to change a password it throws an error
ERROR:
ORA-28001: the password has expired
So cant u trace this error from ur frontend and write a piece of code to popup a password change window whenever such thing happens and store that password back to the database.
U jst need to know how errors are traced and handled in ur S/W.
Regards,
tarun
|
|
|
|