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.
Fragment-Level Privileges
Effect of Fragment-Level Authorization in Statement Validation

Effect of Fragment-Level Authorization in Statement Validation

Fragment-level privilege enables users to execute INSERT, DELETE, and UPDATE data manipulation language (DML) statements on table fragments, even if the grantees lack Insert, Update, and Delete privileges on the table as a whole. Users who lack the table privileges can insert, delete, and update rows in authorized fragments because of the algorithm by which the database server validates DML statements. This algorithm consists of the following checks:

When a user executes an INSERT, DELETE, or UPDATE statement, the database server first checks whether the user has the table privileges necessary for the operation attempted. If the table privileges exist, the statement continues processing.
If the table privileges do not exist, the database server checks whether the table is fragmented by expression. If the table is not fragmented by expression, the database server returns an error to the user. This error indicates that the user does not have the privilege to execute the statement.
If the table is fragmented by expression, the database server checks whether the user holds the fragment privileges necessary for the attempted operation. If the user holds the required fragment privileges, the database server continues to process the statement. If the fragment privileges do not exist, the database server returns an error to the user. This error indicates that the user does not have the privilege to execute the statement.