SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-199
Syntax Description of GRANT
TO {authid [,authid ]... | PUBLIC}
specifies one or more users to whom you grant privileges.
authid specifies an authorization ID to whom you grant privileges. 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 not allowed. authid is not case-sensitive.
SQL:1999 specifies two special authorization IDs: PUBLIC and SYSTEM.
•
PUBLIC specifies all present and future authorization IDs.
•
SYSTEM specifies the implicit grantor of privileges to the creators of objects.
You cannot specify SYSTEM as an authid in a GRANT statement.
WITH GRANT OPTION
specifies that users of the authorization IDs to whom privileges are granted have
the right to grant the same privileges to other authorization IDs.
BY authid-grantor
specifies the authorization ID authid-grantor on whose behalf the grant
operation is performed. Only the Super ID can use the BY clause unless the
Security Administrators Group is not empty and the Super ID has not been
designated as a Security Administrator in which case the Super ID is denied the
use of this feature. The effect of using the BY clause is the same as if the authid-
grantor were to issue the GRANT directly (without using the BY clause).
authid-grantor cannot be SYSTEM. If the Security Administrator's Group is
empty, then authid-grantor must be a valid authorization ID and hold the
privilege(s) being granted WITH GRANT OPTION. However, if the Super ID is
designated as a Security Administrator, it will have Super GRANT BY capabilities in
which authid-grantor may be any valid authorization ID.