ALL views
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 |