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-209
Examples of GRANT
Privileges on Stored Procedures
You can also manage security on a stored procedure by using the GRANT EXECUTE
and REVOKE EXECUTE statements. See GRANT EXECUTE Statement on
page 2-211 and REVOKE EXECUTE Statement on page 2-248.
Examples of GRANT

This example grants SELECT and DELETE privileges on a table, in addition to the
privilege of granting SELECT and DELETE privileges to others:
GRANT SELECT, DELETE ON TABLE sales.odetail
TO "sql.user1", "sql.user2" WITH GRANT OPTION;

This example grants UPDATE privileges on the named columns to PUBLIC:
GRANT UPDATE (start_date, ship_timestamp)
ON TABLE persnl.project TO PUBLIC;

In this example, the super ID grants SELECT and DELETE privileges on a table on
behalf of sql.user1:
GRANT SELECT, DELETE ON TABLE sales.odetail
TO "sql.user3" BY "sql.user1";
GRANT CREATE CATALOG Statement
Considerations for GRANT CREATE CATALOG
Examples for GRANT CREATE CATALOG
The GRANT CREATE CATALOG grants privileges to create a catalog for specified
users.
{"grantee" [,"grantee"]...}
are the recipients of the GRANT privileges.
Considerations for GRANT CREATE CATALOG
Only authorized users are allowed to create catalog after the successful completion of
the first GRANT CREATE CATALOG statement.
Authorization and Availability Requirements
A security administrator or the Super ID (if Super ID is part of the Security
Administrator’s group or if no Security Administrator’s group exists) can grant the
privilege to create a catalog.

CREATE CATALOG privilege cannot be granted to PUBLIC.
GRANT CREATE CATALOG TO {"grantee" [,"grantee"]...}