Column and table encryption

If you only want to encrypt portions of your database, you can choose to encrypt columns or tables.

Column encryption can be performed on any column in any table at any time. Table encryption requires that the database have table encryption enabled. Table encryption is enabled at database creation (initialization) time.

To encrypt tables You can use the following:
- Initialization utility (dbinit). See Initialization utility (dbinit).
- CREATE DATABASE statement. See CREATE DATABASE statement.
- ALTER DATABASE statement. See ALTER DATABASE statement.
- CREATE ENCRYPTED TABLE DATABASE statement. See CREATE ENCRYPTED DATABASE statement.
To encrypt columns ENCRYPT function. See ENCRYPT function [String].
To encrypt materialized views ALTER MATERIALIZED VIEW statement. See ALTER MATERIALIZED VIEW statement.

Column and table encryption

See also