Wednesday, August 1, 2012

User password expiry check


set linesize 999
set pagesize 999
col expiry_date for a20
select NAME, username , expiry_date , account_status from v$database, dba_users where expiry_date < sysdate+30 and account_status IN ( 'OPEN', 'EXPIRED(GRACE)' )and username IN ('SYSTEM','SYS','DBSNMP')
order by account_status, expiry_date, username
/

No comments:

Post a Comment

Wednesday, August 1, 2012

User password expiry check


set linesize 999
set pagesize 999
col expiry_date for a20
select NAME, username , expiry_date , account_status from v$database, dba_users where expiry_date < sysdate+30 and account_status IN ( 'OPEN', 'EXPIRED(GRACE)' )and username IN ('SYSTEM','SYS','DBSNMP')
order by account_status, expiry_date, username
/

No comments:

Post a Comment

My Blog List