What Is Dba_Users
Dba_Users Describes All Users of the Database. Related View. User_Users Describes the Current User. This View Does Not Display the Password, Profile...
DBA_USERS describes all users of the database. Related View. USER_USERS describes the current user. This view does not display the PASSWORD , PROFILE , PASSWORD_VERSIONS , EDITIONS_ENABLED , AUTHENTICATION_TYPE , and LAST_LOGIN columns.
Is dba_users a view?
The DBA_USERS view describes all users of the database. … ALL_USERS view lists all users of the database that are visible to the current user. SYS. USER_USERS view describes the current user.
What is expiry date in dba_users?
The expiry_date column in the dba_users view gets reset to the value in column CREATED if the password for an account is left unchanged after password has expired. If the password is reset, the expiry_date is correctly calculated.