create archive database for Full Database Encryption

The create archive database command supports the full database encryption feature.

Syntax

create archive database database_name
    encrypt with key_name

Parameters

database_name is the name of the archive database you are creating.
key_name is the same key that you used to encrypt the database that was backed up (dumped). SAP ASE verifies that key_name matches during the database dump. If it does not match, the restoration fails.

Permissions

There is no special permission to use the encrypt with option of the create archive database command. However, users need select permission on the database encryption key to be able to reference it as the key_name.