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 , 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.

Robert Thorne

Robert Thorne

Automotive & Future Transportation Editor

Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.

Share this article
Twitter Facebook Pinterest