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.

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`)
`MFA`	`VARCHAR2(8)`		Additional authentication factors configured for the end user Valid values are `duo_push` for Cisco Duo and `oma_push` for Oracle Mobile Authenticator

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`)
`MFA`	`VARCHAR2(8)`		Additional authentication factors configured for the end user Valid values are `duo_push` for Cisco Duo and `oma_push` for Oracle Mobile Authenticator

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