Security in Pervasive.SQL Prior to V8.5

Versions of Pervasive.SQL prior to V8.5 provide limited database security facilities. The driver supports this limited security only when operating in non-database mode. (Database mode can only be used on Pervasive.SQL V8.5 or later.)

Security in pre-V8.5 versions can be turned on in the Pervasive Control Center. When you enable security, you must provide a password for the ‘Master’ user. This password is also set as an owner name on the DDF files.

The driver needs to know this DDF owner name to access the DDFs. You can pass the DDF owner name by specifying it with the DDF_OWNER keyword in DFBTRDRV.INT:

DDF_OWNER Secret

Note: Owner names are case sensitive.

This implies a security risk, as you need to place the password in the DFBTRDRV.INT in plain ASCII.

You can also pass the owner name at runtime with the DFBTR_DDF_OWNER command.

Example

Use DFBTRDRV.pkg
String sDdfOwnerName
Move "Secret" To sDdfOwnerName
DFBTR_DDF_OWNER sDdfOwnerName