EncryptionPass database parameter
Description
Specifies
a password for encrypting and decrypting data.
When to specify EncryptionPass
You must specify the EncryptionPass parameter before connecting
to the database.
Controls
-
I10 Informix
Syntax
|
1 |
EncryptionPass='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
A string that will be used as the password |
Default
None.
Usage
In IDS 10.0 and later, the SQL statement SET
ENCRYPTION PASSWORD can improve the confidentiality of
data and support data integrity by defining or resetting a password
for encryption and decryption of data at the column level.
You can set the EncryptionPass and Hint static DbParameters
on the System tab page in the Database Profile Setup dialog box
for I10 connections to specify a password and an optional hint to
help you remember the password. The password does not display in
the database Profile Setup dialog box and is encrypted in the database
profile in the registry. The application uses built-in Informix
functions to encrypt and decrypt character data.
Examples
To specify Archimedes as the password for data encryption
and Eureka as the hint to help you remember the password:
-
Database profile
Enter Archimedes in the Encryption Password box and Eureka
in the Hint box on the System page in the Database Profile Setup
dialog box. -
Application
Type the following in code:
1SQLCA.DbParameter="EncryptionPass='Archimedes',<br>Hint='Eureka'"