First page Back Continue Last page Graphics

Miscellaneous Views

SESSION_PRIVS
- Active system privileges
DICTIONARY
- Name and descriptions of all data dictionary views available to my user
- See next page…
DICT_COLUMNS
- Column descriptions for dictionary views available to my user
TABLE_PRIVILEGES
- Privileges for objects for which the user is the grantor, grantee or owner, or PUBLIC is the grantee

Notes:

There are several useful views that do not fit neatly into the categories we have discussed in this lesson. These include:
SESSION_PRIVS – Contains system privileges active for the current user and session.
DICTIONARY (DICT) – Contains the name and a brief description (in most cases) of all data dictionary views.
DICT_COLUMNS – Contains the name and a brief description of each column of every data dictionary view.
TABLE_PRIVILEGES – Contains object privileges for the current user.
You will see an example of querying the DICTIONARY view on the next page.
Again, don’t concern yourself with trying to remember every detail on each of these views. Later in this course you will be presented each view again when it will help your understanding of a subject.