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-244
Considerations for GRANT CREATE CATALOG
{"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.
•
CREATE CATALOG privilege cannot be granted to any member of the Security
Administrator’s group.
Examples for GRANT CREATE CATALOG
•
This example grants users, “SQL.USER1”, “SQL.USER2”, and “SQL.USER3” with
the privilege to create a catalog:
GRANT CREATE CATALOG TO "SQL.USER1";
GRANT CREATE CATALOG TO "SQL.USER2", "SQL.USER3";
GRANT CREATE SCHEMA Statement
Considerations for GRANT CREATE SCHEMA
Example for GRANT CREATE SCHEMA
The GRANT CREATE SCHEMA grants privileges to create a schema on a specified
catalog to specified users.
{"grantee" [,"grantee"]...}
are the recipients of the GRANT privileges.
catalog
is the name of the catalog, under which the recipients of the GRANT CREATE
SCHEMA privilege can create the schema.
GRANT CREATE SCHEMA ON catalog TO {"grantee" [,"grantee"]...}