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-206

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-211.

(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] 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-211.

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.

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.