| Could I use trigger to move 'EXPIRED' to 'LOCKED' ? [message #302046] |
Fri, 22 February 2008 15:52  |
dhar
Messages: 9
Registered: February 2008
|
Junior Member |
|
|
Hi,
I'm currently developing a password management policy for my organisation. I'm using Oracle 8i. I observed the following :
(1) The value in the 'account_status' field of table, dba_users,
is set to 'EXPIRED'(expired-grace time etc....) when a user attempts to logon, given that the password has expired.
(2) The value in the 'account_status' field of table, dba_users, is set to 'LOCKED' when user account is locked after x number of failed logn attempts etc..
These changes appears to be an Oracle- initiated actions, that is, they are executed automatically.
I would like to IMMEDIATELY change an 'EXPIRED' state to 'LOCKED' state whenever a user password expires.
Could this be done ??? I' thinking about a database trigger....that detects when the 'account_status' goes to 'EXPIRED' and changes it to 'LOCKED' immediately.
but I've read that these operate for insert, update, delete operations ONLY...could it be used for my purposes ??
I'm new to Oracle/triggers...I would appreciate any assistance please.....
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
