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.
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 ... |
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.