beautypg.com

Display materialized views and their properties – HP Neoview Release 2.4 Software User Manual

Page 60

background image

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