19.2 Identity Views

These views help you validate application identity and end-user configurations.

Summary of views

View or Object Name Description
DBA_END_USERS Displays all local end users defined in the database.
USER_END_USERS Displays the current end user's own account information.
DBA_APPLICATION_IDENTITIES Displays all application identities defined in the database.

19.2.1 DBA_END_USERS

Displays all local end users defined in the database. Use this view to query account status, authentication type, password expiry, profile associations, and effective time ranges for each end user.

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 of the end user. Valid values: OPEN, EXPIRED, EXPIRED(GRACE), LOCKED, LOCKED(TIMED), EXPIRED & LOCKED, EXPIRED(GRACE) & LOCKED, EXPIRED & LOCKED(TIMED), OPEN & IN ROLLOVER, EXPIRED & IN ROLLOVER, LOCKED & IN ROLLOVER, EXPIRED & LOCKED & IN ROLLOVER, EXPIRED & LOCKED(TIMED) & IN ROLLOVER

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)

19.2.2 USER_END_USERS

Displays the current end user's own account information. This view is restricted to the session's authenticated end user and exposes a subset of the columns available in DBA_END_USERS.

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 of the current end user. Valid values: OPEN, EXPIRED, EXPIRED(GRACE), LOCKED, LOCKED(TIMED), EXPIRED & LOCKED, EXPIRED(GRACE) & LOCKED, EXPIRED & LOCKED(TIMED), OPEN & IN ROLLOVER, EXPIRED & IN ROLLOVER, LOCKED & IN ROLLOVER, EXPIRED & LOCKED & IN ROLLOVER, EXPIRED & LOCKED(TIMED) & IN ROLLOVER

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

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.

MANDATORY_PROFILE_VIOLATION

BOOLEAN

Indicates whether the end user account password violates the mandatory profile's password complexity requirements (TRUE) or not (FALSE)

19.2.3 DBA_APPLICATION_IDENTITIES

Displays all application identities defined in the database. Application identities represent service principals or middleware applications.

Column Datatype NULL Description

APPLICATION_NAME

VARCHAR2(128)

Name of the application identity

APPLICATION_ID

NUMBER

NOT NULL

Unique identifier number for the application identity

MAPPED_TO

VARCHAR2(4000)

External identifier string for the application identity