Neoview SQL Reference Manual (R2.4 SP2)

GRANT Statement
• “Syntax Description of GRANT”
• “Considerations for GRANT”
• “Examples of GRANT”
The GRANT statement grants access privileges for a Neoview SQL table, view, or materialized
view to specified roles or through a synonym of a table, view, or materialized view. See
“Privileges” (page 288).
GRANT { privilege [,privilege]... | ALL [PRIVILEGES] }
ON [TABLE] object
TO {grantee [,grantee ]... }
[WITH GRANT OPTION]
grantee is:
authid
privilege is:
DELETE
| INSERT
| SELECT
| UPDATE [(column [,column]...)]
| REFERENCES [(column [,column]...)]
Syntax Description of GRANT
privilege [,privilege]...| ALL [PRIVILEGES]
specifies the privileges to grant. You can specify each of these privileges for a table, view, or
materialized view.
Can use DELETE statement.DELETE
Can use INSERT statement.INSERT
Can use UPDATE statement.UPDATE
Can create constraints or triggers that reference the
object.
REFERENCES
Can use SELECT statement.SELECT
All the privileges above. When ALL is specified, the
object can be a table, view, or materialized view.
ALL PRIVILEGES
(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, view, or materialized view.
ON [TABLE]object
specifies a table, view or materialized view on which to grant privileges.
TO {grantee [,grantee]... }
specifies one or more roles to whom you grant privileges.
GRANT Statement 135