RDB$ENCRYPTIONS
Go Up to System Tables
RDB$ENCRYPTIONS describes the characteristics of encryptions stored in the database.
| Column name | Data type | Length | Description |
|---|---|---|---|
|
RDB$ENCRYPTION_NAME |
|
67 |
A unique name for the encryption. |
|
RDB$ENCRYPTION_TYPE |
|
16 |
BASE: Defines a base encryption that has its own encryption value. COPY: Copy of a BASE encryption that shares the same encryption value. BACKUP: Defines an encryption used to encrypt database backup files. RECOVERY: Defines an encryption that can be used to recover a password-protected encryption when the password has been lost or forgotten. This encryption cannot be used to perform database encryption |
|
RDB$ENCRYPTION_CIPHER |
|
16 |
Encryption cipher algorithm. This is either AES (Advanced Encryption Standard) or DES (Data Encryption Standard). |
|
RDB$ENCRYPTION_ LENGTH |
|
Encryption key length (bits) must be one of these values for AES: 128, 192 or 256. The default is 128. For DES the default is 56. | |
|
RDB$ENCRYPTION_INIT_ VECTOR |
CHAR |
6 |
RANDOM: specifies that random bytes should be used with cipher block chaining (CBC) encryption mode. <null>: default, specifies electronic cookbook (ECB) encryption mode used. |
|
RDB$ENCRYPTION_PAD |
CHAR |
6 |
RANDOM: pads value to be encrypted with random bytes. |
|
RDB$ENCRYPTION_VALUE |
CHAR |
68 |
Encrypted value of the actual encryption key value. |
|
RDB$ENCRYPTION_SALT |
CHAR |
68 |
Hash to verify decrypted value of actual encryption key value is correct. |
|
RDB$ENCRYPTION_ TIMESTAMP |
TIMESTAMP |
Timestamp when encryption key value was created or refreshed. | |
|
RDB$ENCRYPTION_ID |
SMALLINT |
Unique identifier for Encryption key. | |
|
RDB$SECURITY_CLASS |
CHAR |
67 |
Names a security class stored in RDB$SECURITY_CLASSES. |
|
RDB$OWNER_NAME |
CHAR |
67 |
Owner of the encryption |
|
RDB$PASSWORD2 |
VARCHAR |
68 |
Password hash used to allow access to the encryption. |
|
RDB$SYSTEM_FLAG |
SMALLINT |
0: User-defined 1: System-defined. | |
|
RDB$FLAGS |
SMALLINT |
2 |
1: random initialization vector defined for cipher block chaining encryption mode. 2: random padding of plaintext 4: encryption is marked for deletion. 32: indicates one or more subscriptions on the relation |
|
RDB$DESCRIPTION |
BLOB |
Subtype Text: User-written description of encryption. |