sa_db_option( 
opt 
, val 
)

Database administrators can use this procedure to override some database options temporarily, without restarting the database.

The option values that are changed using this procedure are reset to their default values when the database shuts down. To change an option value every time the database is started, specify the corresponding database option when the database is started (if one exists).

The following option settings can be changed:

You must have the SERVER OPERATOR system privilege.

None.

• -sbx database server option
• disk_sandbox option
• sa_server_option system procedure

In order for the following example to work, the server must be started with the option: -sk securefkey.

This example enables the SYSTEM secure feature set which includes MANAGE_KEYS, creates a new secure feature key called SECURITY with case-sensitive authorization key newsecuritykey, and then uses the new secure feature key to enable the DiskSandbox option.

CALL sp_use_secure_feature_key( 'system', 'securefkey' );
CALL sp_create_secure_feature_key( 'security', 'newsecuritykey', 'manage_security' );
CALL sp_use_secure_feature_key( 'security', 'newsecuritykey' );
CALL sa_db_option( 'DiskSandbox', 'on' );