DBA_END_USERS

DBA_END_USERS displays all Oracle Deep Data Security (Deep Sec) local end users defined in the database.

USER_END_USERS displays the current Deep Sec end user’s account information. This view does not display the PROFILE, SCHEMA, START_TIME, or END_TIME columns.

Column Datatype NULL Description
USERNAME VARCHAR2(128)   Name of the end user
USER_ID NUMBER NOT NULL Unique identifier number for the end user
ACCOUNT_STATUS VARCHAR2(32) NOT NULL

Account status for the end user

Refer to the ACCOUNT_STATUS column in "DBA_USERS" for a list of statuses and their meanings.

LOCK_DATE DATE  

Date on which the end-user account was locked

This column is populated only when ACCOUNT_STATUS = LOCKED.

EXPIRY_DATE DATE   Date of expiration for the end-user account
CREATED_DATE DATE   Creation date for the end-user account
PROFILE VARCHAR2(128)   Name of the database profile associated with the end user
AUTHENTICATION_TYPE VARCHAR2(8)  

Authentication mechanism for the end user:

  • NONE - Not configured with a password

  • PASSWORD - Configured with a password

PASSWORD_CHANGE_DATE DATE  

Date on which the end user's password was last set

This column is populated only when AUTHENTICATION_TYPE = PASSWORD.

SCHEMA VARCHAR2(128)   Schema for object name resolution associated with the end user
START_TIME VARCHAR2(28)   Effective start time for the end user
END_TIME VARCHAR2(28)   Effective end time for the end user
MANDATORY_PROFILE_VIOLATION BOOLEAN   Indicates whether the end user account password violates the mandatory profile’s password complexity requirements (TRUE) or not (FALSE)
MFAFoot 1 VARCHAR2(8)   Additional authentication factors configured for the end user

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.3.

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.2.

See Also: “USER_END_USERS”