SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-3
Data Definition Language (DDL) Statements
DROP TRIGGER Statement on
page 2-191
Drops a trigger.
DROP VIEW Statement
on
page 2-192
Drops a view.
EXPLAIN Statement
on page 2-207 Generates and displays the result of the EXPLAIN
function.
GIVE CATALOG Statement
on
page 2-235
Transfers the ownership of catalog from one
Guardian user to another.
GIVE Object Statement
on
page 2-236
Transfers the ownership of the object from one
Guardian user to another.
GIVE SCHEMA Operation on
page 2-238
Transfers the ownership of a schema, and
optionally the ownership of objects within the
schema owned by the schema owner from one
user to another.
GRANT Statement on page 2-239 Grants access privileges to users for a table, view,
sequence generator or stored procedure.
GRANT CREATE CATALOG
Statement on page 2-243
Grants privileges to create a catalog for specified
users.
GRANT CREATE SCHEMA
Statement on page 2-244
Grants privileges to create a schema on a specified
catalog to specified users.
GRANT EXECUTE Statement
on
page 2-245
Grants access privileges for a procedure to specified
users.
GRANT SECURITY_ADMIN
Statement on page 2-248
Grants security administration privileges to
designated users.
INITIALIZE SQL Statement
on
page 2-250
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-316 Revokes access privileges for a table, view, or
sequence generator.
REVOKE CREATE CATALOG
Statement on page 2-319
Revokes the privilege to create a catalog from
specified users.
REVOKE CREATE SCHEMA
Statement on page 2-320
Revokes the privilege to create a schema on a
specified catalog to specified users.
REVOKE EXECUTE Statement
on
page 2-322
Revokes access privileges for a procedure to
specified users.