The Oracle Data Dictionary contains information about data base objects, users and events. You can access this information through these views of the data dictionary.
| View | Description |
|---|---|
| USER_ROLE_PRIVS | Roles granted to the user. |
| USER_TABLES aka TABS | Description of the user's own tables. |
| USER_TAB_COLUMNS aka COLS | Columns of user's tables, views and clusters. |
| USER_TAB_PRIVS | Grants on objects for which the user is the owner, grantor or grantee |
| USER_VIEWS | Test of views owned by the user. |
| USER_TRIGGERS | Descriptions of the user's triggers |
| USER_OBJECTS aka OBJ | Objects owned by the user |
| USER_INDEXES aka IND | Description of the user's own indexes |
| USER_IND_COLUMNS | Columns of the user's indexes or on user's tables |
| USER_SEQUENCES | Description of the user's own sequences |
| USER_SOURCE | The text source of the stored objects |
