SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-139
Syntax Description of GRANT
ON [TABLE] object
specifies a table, view, or stored procedure on which to grant privileges. When the
object is a stored procedure, the only privileges you can specify are ALL
PRIVILEGES or EXECUTE. See GRANT EXECUTE Statement on page 2-141.
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 a SUPER user can use the BY clause. 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 must be a valid authorization ID and cannot be SYSTEM.