| User expire after certain time [message #113257] |
Thu, 31 March 2005 22:13  |
Hina
Messages: 51
Registered: April 2004
|
Member |
|
|
1. What is the parameter, so a user will be expired after every 30 days ?
2. Whenever a new user gets created, how should it ask for new password, so a user can change their own password ?
3. Expire time e.g (30 days) would match according to on server side, or client side ?
Regards
|
|
|
|
| Re: User expire after certain time [message #113284 is a reply to message #113257] |
Fri, 01 April 2005 01:16  |
deepa_balu
Messages: 74
Registered: March 2005
|
Member |
|
|
Whenever a new user gets created, how should it ask for new password, so a user can change their own password ?
Check this out:
SQL> create user test identified by test password expire;
User created.
SQL> connect test/test
ERROR:
ORA-28001: the password has expired
Changing password for test
New password:
Retype new password:
Hope this helps!
1. What is the parameter, so a user will be expired after every 30 days ?
u can create a profile and assign that profile to that user there u can specify the expairy of days.
|
|
|
|
|
|
|
|
| Re: User expire after certain time [message #114860 is a reply to message #113257] |
Tue, 05 April 2005 21:10 |
win_vj
Messages: 16
Registered: March 2005
Location: India
|
Junior Member |
|
|
Why don't u go for profile. Just create a profile as given below.
1. CREATE PROFILE Pass_Expire LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 30;
2. ALTER USER USERNAME PROFILE Pass_Expire;
This profile will not allow 6th failed attempt and it will lock the account and Password has to be changed within 30 days. If a user dosen't change the password within 30 days, That password will expire.
If you are working on Client/Server, It will always follow the database server time.
Vijay
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
