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™These topics document 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.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
Column-level encryptionYou can use column-level encryption to store sensitive data in an encrypted format. After encrypting sensitive data, such as credit card numbers, only users who can provide a secret password can decrypt the data.
Encrypting column dataYou can store sensitive data in encrypted format.
Example showing how to query encrypted dataYou can query encrypted data with the DECRYPT function or the SET ENCRYPTION PASSWORD statement.

Example showing how to query encrypted data

You can query encrypted data with the DECRYPT function or the SET ENCRYPTION PASSWORD statement.

The following example shows how to use the decrypt function to query encrypted data:

select name, decrypt_char(ssn, "one two three 123") from emp;
        or
set encryption password "one two three 123";
select name, salary, decrypt_char(ssn) from emp where name = 'Bob';