|Lesson 14||Users in the data Dictionary |
|Objective ||View user information in the Data Dictionary|
Users in the Oracle Data Dictionary
Several data dictionary views can be used to retrieve information about users. The following MouseOver shows some of the views related to what you have learned in this chapter.
Viewing User Information
For the most part, it should be fairly obvious how to query these views. The column names explain their contents quite well.
Listing the privileges for a user
The following query may be used to list all the system privileges that have been granted to a user:
Replace username with the name of the user who's privileges you are researching. Usernames should normally be specified in upper-case form. For example, use '
SYSTEM', not '
Listing a user's tablespace quotas
To determine a user's tablespace quotas and find out how much space has actually been used, you can use this query:
WHERE username = 'USERNAME';
As with the previous query, the username should be upper-case. A quota of -1 indicates that the user has been given unlimited quota on a tablespace
Data Dictionary - Queries - Exercise