DBA_USER

DBA_USERS

DBA_USERS is a default view in oracle database which describes all users of the database.

This view contains information about the users in the oracle database like username, user_id, password, account_status, lock_date, expiry_date, default_tablespace, temporary_tablespace, local_temp_tablespace, created, profile, password_versions.

Column description:

Username:

Contains the name of the user.

User_id:

Contains ID number of the user.

Password:

This column is deprecated in favour of the AUTHENICATION_TYPE column.

Account_status:

This column shows the status of the account as below:

• open
• expired
• expired (grace)
• locked (timed)
• locked
• expired & locked (timed)
• expired (grace) & locked (timed)
• expired & locked

Lock_date:

show the date of account locked if the account was in locked status.

Expiry_date:

Shows the date of expiration of the account.

Default_tablesapce:

Contains the default tablespace name which is assigned to user as default for data.

Temporary_tablespace:

Contains the default tablespace name which is assigned to user as default for temporary data.

Local_temp_tablspace:

Contains the default local temporary tablespace name for the user.

Note: This is available from oracle database 12c.

Created:

Contains the date on which the user has been created.

Profile:

Contains the profile name for the user.

Initial_RSRC_Consumer_group:

Initial resource consumer group for the user.

External_Name:

Contains user external name.

Also, there is a view similar to dba_users is user_users which has information only about the user which you have logged in.

loading...