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-245
Considerations for GRANT CREATE 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.
Example for GRANT CREATE SCHEMA
•
This example grants the users, “SQL.USER1” and “SQL.USER2” with the privilege
to create a schema within the catalog:
GRANT CREATE SCHEMA ON CAT TO "SQL.USER1", "SQL.USER2";
GRANT EXECUTE Statement
Considerations for GRANT EXECUTE
Examples of GRANT EXECUTE
The GRANT EXECUTE statement grants privileges for calling a stored procedure in
Java (SPJ) to one or more specified users.
EXECUTE
specifies the privilege of calling the stored procedure.
GRANT EXECUTE
ON [PROCEDURE] procedure-ref
TO {grantee [,grantee ]...}
[WITH GRANT OPTION]
[BY authid-grantor]
procedure-ref is:
[[catalog-name.]schema-name.]procedure-name
grantee is:
authid | PUBLIC