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-211
Example for GRANT CREATE SCHEMA
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.
ON [PROCEDURE] procedure-ref
specifies the ANSI logical name of a stored procedure on which to grant EXECUTE
privilege, of the form:
[[catalog-name.]schema-name.]procedure-name
where each part of the name is a valid SQL identifier with a maximum of 128
characters. For more information, see Identifiers
on page 6-56.
TO {authid [,authid ]... | PUBLIC}
specifies one or more users to whom you grant EXECUTE privilege.
authid specifies an authorization ID to whom you grant the EXECUTE privilege.
Authorization IDs identify users during the processing of SQL statements. The
authorization ID must be a valid Guardian user name, enclosed in double quotes.
A Guardian user number (for example, “255,255”) is disallowed. authid is not
case-sensitive.
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