ALL_ data dictionary views provide metadata for all objects that the current user has access to, including objects owned by other users.
The following table provides an overview of the Oracle data dictionary views included in the ALL_ group.
| Function | Description |
|---|---|
| ALL_ARGUMENTS | Provides information about the procedure and function arguments accessible to the current user. |
| ALL_COL_PRIVS | Provides information about column-level object grants where the current user is the object owner, grantor, grantee, or where an enabled role or PUBLIC is the grantee. |
| ALL_CONS_COLUMNS | Provides information about columns included in constraints and accessible to the current user. |
| ALL_CONSTRAINTS | Provides information about constraint definitions on accessible tables. |
| ALL_INDEXES | Provides information about the table indexes accessible to the current user. |
| ALL_OBJECTS | Provides information about all database objects accessible to the current user. |
| ALL_PROCEDURES | Provides information about all PL/SQL functions and procedures, along with associated properties, that are accessible to the current user. |
| ALL_SYNONYMS | Provides information about the synonyms accessible to the current user. |
| ALL_TAB_COLUMNS | Provides information about the columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_PRIVS | Provides information about the object privileges granted to the current user, the object privileges granted by the current user, the list of object privileges granted for objects owned by the current user, and the object privileges granted to PUBLIC. |
| ALL_TABLES | Provides information about all tables accessible to the current user. |
| ALL_USERS | Provides information about all users of the database that are visible to the current user. |
| ALL_VIEWS | Provides information about all views accessible to the current user. |