Data Dictionary Information About Profiles, Password Management, and Resources

Table 16.1 provides a list of all the views that can be used to get information on users, their passwords, profiles, and resources.

Table 16.1. Data Dictionary Views for Profiles

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.