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-210
Examples for GRANT CREATE CATALOG

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.
Considerations for GRANT CREATE SCHEMA
Only authorized users are allowed to create schema after the successful completion of
the first GRANT CREATE SCHEMA statement in the target catalog.
Authorization and Availability Requirements
A security administrator or catalog owner 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 schema.

CREATE SCHEMA privilege cannot be granted to PUBLIC.

CREATE SCHEMA privilege cannot be granted to any member of the Security
Administrator’s group unless the GRANTOR is the owner of the catalog.
GRANT CREATE SCHEMA ON catalog TO {"grantee" [,"grantee"]...}