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

Querying SQL/MX Metadata

HP NonStop SQL/MX Installation and Management Guide—523723-004

8-58

Displaying Information About Privileges

Topics in this subsection:

•

Displaying All Privileges for a Table on page 8-59

•

Displaying All Privileges for a View on page 8-60

•

Displaying All Privileges for a Column on page 8-61

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 Table 8-1 on page 8-6 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.