Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
GRANT FRAGMENT statementUse the GRANT FRAGMENT statement to assign privileges on table fragments in the local database if the table is fragmented by expression.

GRANT FRAGMENT statement

Use the GRANT FRAGMENT statement to assign privileges on table fragments in the local database if the table is fragmented by expression.

Syntax

Notes:

¹ See Fragment-Level Privileges


Element	Description	Restrictions	Syntax
fragment	Name of a fragment	Must exist; cannot be delimited by quotation marks	Identifier
grantor	User who can revoke the privileges	Same as for user	Owner name
owner	User who owns table	Must be owner of table	Owner name
role	Role to receive privileges	Must exist in sysusers	Owner name
table	Fragmented table on which fragment privileges are granted	Must exist and must be fragmented by expression	Identifier
user	User to whom privileges are to be granted	Must be a valid authorization identifier	Owner name

Usage

This statement is an extension to the ANSI/ISO standard for SQL.

Use the GRANT FRAGMENT statement to grant to users (or roles) any of the Insert, Update, and Delete access privileges on individual fragments of a table. The GRANT FRAGMENT statement is valid only for tables that are fragmented according to an expression-based distribution scheme. For an explanation of this type of fragmentation strategy, see Expression Distribution Scheme.