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