Home
SecurityYou can secure your HCL OneDB™ database server and the data that is stored in your HCL OneDB™ databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
Security in HCL OneDB™The HCL OneDB™ Security Guide documents methods for keeping your data secure by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database server.
Securing data
Label-Based Access ControlYou can use label-based access control (LBAC), an implementation of multi-level security (MLS), to control who has read access and who has write access to individual rows and columns of data.
DBSECADM role in LBACThe database security administrator role (DBSECADM) is required to create and maintain label-based access control security objects.
Granting the DBSECADM RoleA DBSA uses the GRANT DBSECADM statement to give database security administrator authority to a user.

Granting the Database Security Administrator role

A DBSA uses the GRANT DBSECADM statement to give database security administrator authority to a user.

Before you begin

You must be a DBSA to grant DBSECADM.

Grant the DBSECADM role by issuing the GRANT DBSECADM statement, as described in the HCL OneDB™ Guide to SQL: Syntax.

The following statement gives DBSECADM authority to user sam:

GRANT DBSECADM TO sam;