SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Querying SQL/MX Metadata

HP NonStop SQL/MX Installation and Management Guide—544536-007

8-56

Displaying Information About Privileges

Topics in this subsection:

•

Displaying All Privileges for a Table on page 8-57

•

Displaying All Privileges for a View on page 8-58

•

Displaying All Privileges for a Column on page 8-59

The TBL_PRIVILEGES table, located in the schema

DEFINITION_SCHEMA_VERSION_version-number of each catalog, describes the

privileges for all tables and views in that catalog. The COL_PRIVILEGES table, located

in the schema DEFINITION_SCHEMA_VERSION_version-number of each catalog,

describes the privileges for all columns in that catalog. For detailed information about

all metadata tables, see Figure 8-2 on page 8-7 in this manual or the SQL/MX

Reference Manual.

All queries for information about privileges must access information from the CATSYS,

SCHEMATA, and OBJECTS tables, and from other appropriate tables, such as the

TBL_PRIVILEGES table.

The SHOWDDL command does not display information about privileges.