Table 16.1 provides a list of all the views that can be used to get information on users, their passwords, profiles, and resources.
View
Description
DBA_USERS
The DBA view describes all the users of the database.
ALL_USERS USER_USERS
The ALL view lists all the users of the database, but does not describe those users. The USER view describes only the currently connected user.
DBA_TS_QUOTAS USER_TS_QUOTAS
Describes tablespace quotas for users: DBA for all users, and USERS for just the connected user.
USER_PASSWORD_LIMITS
Describes the password profile parameters that have been assigned to the connected user.
USER_RESOURCE_LIMITS
Displays the resource limits assigned for the current user.
DBA_PROFILES
Displays all profiles in the database and all their limits.
RESOURCE_COST
Lists the costs that have been assigned for each resource.