DBA Data[Home] [Help]

VIEW: SYS.USER_XS_USERS

Source

View Text - Preformatted

select name, status, account_status, lock_date, expiry_date,
 direct_logon_user, description
from dba_xs_users
where name = xs_sys_context('XS$SESSION','CURRENT_XS_USER')
View Text - HTML Formatted

SELECT NAME
, STATUS
, ACCOUNT_STATUS
, LOCK_DATE
, EXPIRY_DATE
, DIRECT_LOGON_USER
, DESCRIPTION FROM DBA_XS_USERS WHERE NAME = XS_SYS_CONTEXT('XS$SESSION'
, 'CURRENT_XS_USER')