The following table lists views that have information about all accessible data. Regular database users have access to these views.
| View Name | Description |
|---|---|
| ALL_CATALOG | All accessible database objects |
| ALL_COL_COMMENTS | Comments for all accessible columns |
| ALL_COL_PRIVS | Column privileges where you are involved |
| ALL_COL_PRIVS_MADE | Column privileges where you are the grantor |
| ALL_COL_PRIVS_RECD | Column privileges where you are the grantee |
| ALL_CONS_COLUMNS | All accessible constraint columns |
| ALL_CONSTRAINTS | All accessible constraint definitions |
| ALL_INDEXES | Descriptions of all accessible indexes |
| ALL_IND_COLUMNS | Column descriptions of all accessible indexes |
| ALL_IND_EXPRESSIONS | Expressions of all accessible function-based indexes |
| ALL_MVIEWS | Descriptions for all accessible materialized views |
| ALL_NESTED_TABLE_COLS | All accessible columns of nested tables |
| ALL_NESTED_TABLES | All accessible nested tables |
| ALL_OBJECTS | All accessible database objects |
| ALL_SEQUENCES | All accessible sequences |
| ALL_SYNONYMS | Synonyms |
| ALL_TABLES | All accessible tables |
| ALL_TAB_COLS | Column descriptions for all accessible tables |
| ALL_TAB_COLUMNS | Column descriptions for all accessible tables without hidden columns |
| ALL_TAB_COMMENTS | All comments for accessible tables |
| ALL_TAB_PRIVS | Table privileges |
| ALL_TAB_PRIVS_MADE | Table privileges where you are object owner or grantor |
| ALL_TAB_PRIVS_RECD | Table privileges where you are the privilege grantee |
| ALL_UPDATABLE_COLUMNS | Accessible updatable join view columns |
| ALL_USERS | Information about all database users |
| ALL_VIEWS | Information about all accessible views |