Database Administration (MOSC)

MOSC Banner

User account status showin as 'OPEN' but expiry date showing less then sysdate

edited Feb 20, 2014 2:13AM in Database Administration (MOSC) 9 comments

Please find below SQL output

SQL>  select username,expiry_date,account_status from dba_users where account_st

atus='OPEN' and expiry_date < sysdate;

USERNAME                       EXPIRY_DA ACCOUNT_STATUS

------------------------------ --------- --------------------------------

SYSTEM                         01-OCT-12 OPEN

SYS                            02-FEB-14 OPEN

SYS_2                          02-FEB-14 OPEN

MGMT_VIEW                      01-OCT-12 OPEN

SQL>

My query is even expiry_date is less then sysdate How account_status is showing 'OPEN' or Why it's not updated expiry date while changing password?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center