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-240
Syntax Description of GRANT
Syntax Description of GRANT
privilege [,privilege]... | ALL [PRIVILEGES]
specifies the privileges to grant. You can specify each of these privileges for a table
or a view. See also the GRANT EXECUTE Statement on page 2-245.
(column [,column]...)
names the columns of the object to which the UPDATE or REFERENCES
privileges apply. If you specify UPDATE or REFERENCES without column
names, the privileges apply to all columns of the table or view.
ON [TABLE | SEQUENCE] object
specifies a table, view, sequence generator 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-245.
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.
SELECT Can use SELECT statement.
DELETE Can use DELETE statement.
INSERT Can use INSERT statement.
UPDATE Can use UPDATE statement.
REFERENCES Can create constraints that reference the object.
USAGE Can use the pseudocolumns, CURRVAL and NEXTVAL to
access sequence generator values.
ALL PRIVILEGES
Can have all privileges that apply to the object type.
When ALL is specified, the object can be a table, view,
sequence generator, or stored procedure. When the object
is a stored procedure and ALL is specified, only EXECUTE
permission is applied. When the object is a sequence gen-
erator and ALL is specified, only USAGE privilege is
applied.