SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Querying SQL/MX Metadata

HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001

8-62

Displaying Information About Privileges

Topics in this subsection:



Displaying All Privileges for a Table on page 8-63



Displaying All Privileges for a View on page 8-64



Displaying All Privileges for a Column on page 8-65

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.