First page Back Continue Last page Graphics
Static Views
Static views
- Contain data about objects, privileges, users, etc.
- Contents change with DDL operations
Three types
- USER_
- Displays only information about current user objects
- e.g. USER_TABLES
- ALL_
- Displays info about users objects and objects privileged to use
- e.g. ALL_TABLES
- DBA_
- Displays all objects, etc.
- e.g. DBA_TABLES
Notes:
The static data dictionary views contain information about database objects such as tables, indexes and procedures. They are called “static” because the contents of the views change only when DDL operations are executed. For example, a row is added to the DBA_TABLES view when any user successfully executes a CREATE TABLE statement. (There are also dynamic views, which we will discuss later in this lesson.)
There are three types of static views, USER, ALL and DBA. Every user can query the USER level views, which contain information about the current user’s objects. Every user can also query the ALL-level views, which contain information about the users objects and objects in other schemas that the user has some privilege on.
Supplemental Information
The DBA-level views can only be accessed by users who have been granted the SELECT_CATALOG_ROLE role, the SELECT ANY DICTIONARY privilege or SELECT privilege on specific views. The SELECT ANY DICTIONARY privilege is, by default, granted to the DBA role. You will study more about privileges and roles later in this course in the lesson Managing Security.