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. For details on how these views/tables are structured and how they are used, please refer to the Oracle Data Base Reference documentation.
There are many more tables and views, but these are the ones frequently used.
Access as P2K user.
| Table/View | Description |
|---|---|
| USER_ROLE_PRIVS | Roles granted to the user. |
| USER_TABLES | Description of the user's own tables. (TABS is an alias) |
| USER_TAB_COLUMNS | Columns of user's tables, views and clusters. (COLS is an alias) |
| 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 | Objects owned by the user (OBJis an alias) |
| USER_INDEXES | Description of the user's own indexes (IND is an alias) |
| USER_IND_COLUMNS | Columns of the user's indexes or on user's tables |
| USER_SEQUENCES | Description of the user's own sequences (SEQ is an alias) |
| USER_SOURCE | The text source of the stored objects |
| USER_JOBS | Describes all jobs owned by the user. |
| USER_ERRORS | Describes current errors on all stored objects |
| USER_ENCRYPTED_COLUMNS | Mintains encryption algorithm information for all encrypted columns in all tables in the user's schema * Not currently supported |
Access as SYSTEM or SYS
