DBA Data[Home] [Help]

VIEW: SYS.GV_$RO_USER_ACCOUNT

Source

View Text - Preformatted

select "INST_ID","USERID","PASSW_EXPIRED","PASSW_IN_GRACE","PASSW_LOCKED","PASSW_LOCK_UNLIM","FAILED_LOGINS","EXPIRATION_AFTER_GRACE","PASSW_LOCK_TIME","CON_ID" from gv$ro_user_account
View Text - HTML Formatted

SELECT "INST_ID"
, "USERID"
, "PASSW_EXPIRED"
, "PASSW_IN_GRACE"
, "PASSW_LOCKED"
, "PASSW_LOCK_UNLIM"
, "FAILED_LOGINS"
, "EXPIRATION_AFTER_GRACE"
, "PASSW_LOCK_TIME"
, "CON_ID"
FROM GV$RO_USER_ACCOUNT