Originally Posted by
robertbalmer
The view dba_users has a column "expiry_date" which you can use to determane the date the password was changed, by using the profile information on "password_life_time" .
Expiry_date column in dba_users will show the date for expired users, then what abt current open account users?????
Code:
USERNAME ACCOUNT_STATUS EXPIRY_DA LOCK_DATE
------------------------------ -------------------------------- --------- ---------
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
PS OPEN
BRUNTM OPEN
LEWISD OPEN
CRYSTAL OPEN
PEOPLE OPEN
OUTLN EXPIRED & LOCKED 22-SEP-05 22-SEP-05
WMSYS EXPIRED & LOCKED 22-SEP-05 22-SEP-05
ORDSYS EXPIRED & LOCKED 22-SEP-05 22-SEP-05
ORDPLUGINS EXPIRED & LOCKED 22-SEP-05 22-SEP-05
MDSYS EXPIRED & LOCKED 22-SEP-05 22-SEP-05
"What is past is PROLOGUE"
Reply With Quote