RDB$ENCRYPTIONS

From InterBase
Jump to: navigation, search

Go Up to System Tables


RDB$ENCRYPTIONS describes the characteristics of encryptions stored in the database.

RDB$ENCRYPTIONS
Column name Data type Length Description

RDB$ENCRYPTION_NAME

CHAR

67

A unique name for the encryption.

RDB$ENCRYPTION_TYPE

CHAR

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

CHAR

16

Encryption cipher algorithm. This is either AES (Advanced Encryption Standard) or DES (Data Encryption Standard).

RDB$ENCRYPTION_ LENGTH

SMALLINT

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.