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.
Granting Privileges to One User or a List of Users

Granting Privileges to One User or a List of Users

About this task

You can grant fragment-level privileges to a single user or to a list of users.

The following statement grants the Insert, Update, and Delete privileges on the fragment of the customer table in part3 to user oswald:

GRANT FRAGMENT ALL ON customer (part3) TO oswald;

The following statement grants the Insert, Update, and Delete privileges on the fragment of the customer table in part3 to users jerome and hilda:

GRANT FRAGMENT ALL ON customer (part3) TO jerome, hilda;