Display materialized views and their properties – HP Neoview Release 2.4 Software User Manual
Page 60
Schema indicates permissions have been applied to the schema.
—
— Object indicates permissions were applied directly to the object whose permissions are
being displayed.
— Column indicates the permissions applied to the column. When an object level privilege
applies to all columns, the individual column privileges are not displayed, otherwise
the individual column level permissions are listed.
•
Privileges: Describes the privilege of the user or role. The value is “All Privileges” or a list
of granted privileges separated by a comma. DDL and DML privileges are grouped
accordingly. For a complete list of privileges, see the GRANT SCHEMA statement information
in the Neoview SQL Reference Manual.
Display Materialized Views and Their Properties
To display the materialized view information:
1.
Start the HP Database Manager and log on using any user ID.
2.
Click the Database area.
3.
Select a system in My Active Systems in the navigation tree.
4.
Select a Schema in the navigation tree.
5.
Click the Materialized Views tab in the right pane and select a materialized view name, or
open the Materialized Views folder and select a materialized view name in the tree. HPDM
displays the materialized views in this schema.
In the right pane, these tabs appear:
•
Attributes tab
•
Partitions tab
•
Usage tab
60
Manage Database Objects