Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
SQL programming
Grant and revoke privileges in applications
Assign roles

Assign roles

Alternatively, the DBA can define a role with the CREATE ROLE statement, and use the GRANT and REVOKE statements to cancel or assign roles to users, and to grant and revoke privileges of roles. For example:

GRANT engineer TO nmartin;

The SET ROLE statement is needed to activate a non-default role. For more information on roles and privileges, see Access-management strategies and Privileges on a database and on its objects. For more information on the GRANT and REVOKE statements, see the HCL OneDB™ Database Design and Implementation Guide. For more information about the syntax of these statements, see HCL OneDB Guide to SQL: Syntax.