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-10

SQL/MX Metadata Tables

Starting with SQL/MX Release 3.1, a new schema, called

SYSTEM_SECURITY_SCHEMA is introduced. Figure 8-3

displays the tables in the

new schema.

Figure 8-3. SQL/MX Metadata Tables

SYSTEM_SECURITY_SCHEMA

PRIVILEGED USERS

PK GRANTEE

PK USER_CLASS

GRANTEE_TYPE

GRANTOR

GRANTOR_TYPE

IS_GRANTABLE

GRANT_TIMESTAMP

MGM PRIVILEGE