Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Security

FairCom DB provides a variety of keywords that can be used for security purposes.

Note: FairCom DB File and User Security are available only when using the client/server operational model.

 
Encryption

 
ADMIN_ENCRYPT

Encrypt the FAIRCOM.FCS file at the time it is created.

 
ADVANCED_ENCRYPTION

Enable advanced encryption for files.

ALLOW_MASTER_KEY_CHANGE

The configuration option ALLOW_MASTER_KEY_CHANGE specifies whether the master password is changeable.

 
CHANGE_ENCRYPTION_ON_COMPACT

Change the encryption attributes of a file using the compact function from a client.

FIPS_ENCRYPTION

When specified, FairComDB uses the OpenSSL 3.0 FIPS module for encryption routines. 

KEY_EXCHANGE_PARAMS

Specifies the PEM-encoded file containing parameters for Diffe-Hellman key exchange.


LOG_ENCRYPT

Camouflages the contents of the transaction logs to deter unauthorized access.

 
MASTER_KEY_FILE

Specifies a file from which c-tree reads the master encryption key.

MASTER_KEY_LIB

Specify the path of a user-created library (.dll, .so, or .dylib file) that provides the advanced encryption master key at startup time.

OPENSSL_ENCRYPTION

Encrypt client passwords with OpenSSL before they are transmitted to the server.

READONLY_SERVER

Sets the server to read-only mode.

 
User Access

 
LOGON_FAIL_LIMIT

Specifies the optional limit on the number of consecutive failed logons that causes subsequent logon attempts to fail for LOGON_FAIL_TIME minutes.

 
LOGON_FAIL_TIME

The length of time logons are blocked after the logon limit is exceeded.

 
LOGON_MUST_TIME

Requires users to log on “at-least-once” within the specified time.

 
STARTUP_BLOCK_LOGONS

Prevents non-ADMIN user logons when the server is started.

 
Tamper-Proof Settings

These keywords affect people's ability to alter system integrity by overriding settings from a command line or by altering configuration files. See also Settings File.

 
NULL_STRING

Defines a symbol that represents a null string so that options can be blocked in the settings file without activating them.

 
COMPATIBILITY NO_COMMAND_LINE

Instructs FairCom DB to ignore command-line arguments.

 
COMPATIBILITY NO_CONFIG_FILE

Instructs FairCom DB to ignore the standard configuration file, ctsrvr.cfg.

 
Restrictions

 
ENABLE_TRANSFER_FILE_API

Enables the file transfer function, ctTransferFile(), which is used to transfer a file to or from the server.

 
FILEDEF_SECURITY_LEVEL

Protects the resource APIs, ADDRES(), UPDRES(), and DELRES(), with safeguards against unauthorized modification of file definition resources such as IFIL definitions, conditional indexes, row-level filters, etc.

 
Security-Related Compatibility Options

 
COMPATIBILITY NONADMIN_FILBLK

Permits a non-ADMIN user to set a file block if the blocking user has the file opened with update permissions.

 
COMPATIBILITY NONADMIN_QUIET

Permits a non-ADMIN user to call ctQuiet() to quiesce the server.

 
COMPATIBILITY NONADMIN_TRANSFER_FILE

Permits a non-ADMIN user to call ctTransferFile() to transfer a file.

 
COMPATIBILITY NON_ADMIN_SHUTDOWN

Allows non-ADMIN users to shut down the Server.

COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD

Instructs FairCom DB to verify the admin password passed as a parameter.

TLS

DEBUG_LOG

Enable logging to facilitate debugging of TLS connections.

SERVER_CERTIFICATE_FILE

Provide the name of the PEM-encoded certificate file that contains this FairCom server's certificate.

SERVER_ENCRYPTED_STORE_FILE

Specify an encrypted password file that is used to decrypt this FairCom server's private key file.

SERVER_PRIVATE_KEY_FILE

Indicates the name of the file containing this FairCom server's private key.

SSL_CIPHERS

Set the encryption ciphers that are allowed to be used for encrypting TLS connections to this FairCom server.

SSL_CONNECTIONS_ONLY

Specify whether clients are allowed to connect to this FairCom server using non-encrypted connections.

VERIFY_CLIENT_CERTIFICATE

Specify whether clients are required to present valid client certificates when connecting or not.

X509_AUTHENTICATION

Specify whether the client's certificate is used for authentication rather than a username/password.

In This Section

ADMIN_ENCRYPT

ADVANCED_ENCRYPTION

ALLOW_MASTER_KEY_CHANGE

CHANGE_ENCRYPTION_ON_COMPACT

COMPATIBILITY NO_COMMAND_LINE

COMPATIBILITY NO_CONFIG_FILE

COMPATIBILITY NON_ADMIN_SHUTDOWN

COMPATIBILITY NONADMIN_FILBLK

COMPATIBILITY NONADMIN_QUIET

COMPATIBILITY NONADMIN_TRANSFER_FILE

COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD

DEBUG_LOG

FIPS_ENCRYPTION

ENABLE_TRANSFER_FILE_API

FILEDEF_SECURITY_LEVEL

KEY_EXCHANGE_PARAMS

LOG_ENCRYPT

LOGON_FAIL_LIMIT

LOGON_FAIL_TIME

LOGON_MUST_TIME

MASTER_KEY_FILE

MASTER_KEY_LIB

NULL_STRING

OPENSSL_ENCRYPTION

READONLY_SERVER

SERVER_CERTIFICATE_FILE

SERVER_ENCRYPTED_STORE_FILE

SERVER_PRIVATE_KEY_FILE

SSL_CIPHERS

SSL_CONNECTIONS_ONLY

STARTUP_BLOCK_LOGONS

VERIFY_CLIENT_CERTIFICATE

X509_AUTHENTICATION

TOCIndex