DBA_END_USERS

5.352 DBA_END_USERS

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

Related View

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 columns 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`)

Note:

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