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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-138
GRANT Statement
GRANT Statement
Considerations for GRANT
Examples of GRANT
The GRANT statement grants access privileges for an SQL/MX table, view, or stored
procedure to specified users. See also GRANT EXECUTE Statement on page 2-141
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-141.
(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.
GRANT {privilege [,privilege]... | ALL [PRIVILEGES]}
ON [TABLE] object
TO {grantee [,grantee ]...}
[WITH GRANT OPTION]
[BY authid-grantor]
grantee is:
authid | PUBLIC
privilege is:
SELECT
| DELETE
| INSERT
| UPDATE [(column [,column]...)]
| REFERENCES [(column [,column]...)]
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.
ALL PRIVILEGES Can have all privileges that apply to the object type.
When ALL is specified, the object can be a table, view, or
stored procedure. When the object is a stored procedure
and ALL is specified, only EXECUTE permission is
applied.