| Password profile [message #471771] |
Tue, 17 August 2010 04:46  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi,
please verify the below doubts:
Question 1:
How to assign a profile to many users (Group of users)? Is there any script available?
Question 2:
Will the account get locked, if the user is not changing the password within the time limit of PASSWORD_GRACE_TIME?
Question 3:
How to Reactivate the account, if the accounts reaches the PASSWORD_LIFE_TIME?
Question 4:
In production how a DBA monitoring the expiry times for all of the users.
Thanks in advance.
|
|
|
|
| Re: Password profile [message #471821 is a reply to message #471771] |
Tue, 17 August 2010 08:37  |
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
|
Senior Member |
|
|
Q1 Probably, should be easy enough to write on
Q2 The password will expire no more no less
Q2 ALTER USER
Q4 User Defined Metric perhaps ?
Why did you post this in the performance tuning topic ?
[Updated on: Tue, 17 August 2010 08:41] Report message to a moderator |
|
|
|
|
|
| Re: Password profile [message #471891 is a reply to message #471830] |
Tue, 17 August 2010 14:05 |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi,
Thanks for answer but need more clarifications.
Q1: ?
Q2: ?
Q4: Is there any script to alarm the DBA before, the password reach it's ceiling?
Thanks in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
