SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-3
Data Definition Language (DDL) Statements
EXPLAIN Statement on page 2-183 Grants access privileges for a table, view, or
sequence to specified users.
GIVE CATALOG Statement
on
page 2-203
Transfers the ownership of catalog from one
Guardian user to another.
GIVE Object Statement
on
page 2-204
Transfers the ownership of the object from one
Guardian user to another.
GRANT Statement
on page 2-205 Grants access privileges for an SQL/MX table, view,
or stored procedure to specified users.
GRANT CREATE CATALOG
Statement on page 2-209
Grants privileges to create a catalog for specified
users.
GRANT CREATE SCHEMA
Statement on page 2-210
Grants privileges to create a schema on a specified
catalog to specified users.
GRANT EXECUTE Statement
on
page 2-211
Grants access privileges for a procedure to specified
users.
GRANT SECURITY_ADMIN
Statement on page 2-213
Grants security administration privileges to
designated users.
INITIALIZE SQL Statement
on
page 2-216
Prepares a local node to run NonStop SQL/MX.
Creates SQL/MX user metadata (UMD) tables,
system metadata, and NonStop MXCS metadata
tables.
REVOKE Statement
on page 2-243 Revokes access privileges for a table, or view from
specified users.
REVOKE CREATE CATALOG
Statement on page 2-246
Revokes the privilege to create a catalog from
specified users.
REVOKE CREATE SCHEMA
Statement on page 2-247
Revokes the privilege to create a schema on a
specified catalog to specified users.
REVOKE EXECUTE Statement
on
page 2-248
Revokes access privileges for a procedure to
specified users.
REVOKE SECURITY_ADMIN
Statement on page 2-251
Revokes security administration privileges from
designated users.
SET Statement
on page 2-290 Controls the action of a BEFORE trigger.
SIGNAL SQLSTATE Statement
on
page 2-306
Enables a trigger execution to raise an exception that
causes both the triggered and triggering statements
to fail.