Many data dictionary tables have three corresponding views:
ALL_view displays all the information accessible to the current user, including information from the current user's schema as well as information from objects in other schemas, if the current user has access to those objects by way of grants of privileges or roles.
DBA_view displays all relevant information in the entire database.
DBA_views are intended only for administrators. They can be queried only by users with the
SYSDBAsystem privilege or
SELECT ANY DICTIONARYprivilege, or
SELECT_CATALOG_ROLErole, or by users with direct privileges granted to them. The
SELECT ANY DICTIONARYprivilege is assigned to the
DBArole when the system is initially installed.
USER_view displays all the information from the schema of the current user. No special privileges are required to query these views.
The columns of the
USER_ views corresponding to a single data dictionary table are usually nearly identical. Therefore, these views are described in full only once in this chapter, at their first occurrence alphabetically, and are listed without full descriptions at their other occurrences.
"Static Data Dictionary View Descriptions" introduces the alphabetical listing of view descriptions that are documented in this manual