PDAC Security

PDAC supports two types of security:

Owner name security (Btrieve)

SQL database security (DDF)

The following details these two security models:

Owner Name Security

Using this security model, you provide the Owner name for the table. See the Pervasive.SQL API Programmer's Reference (Btrieve operation 29, Set Owner) for more information.

The TPvTable has the property Owner: string and the following method:

SetOwnerOnTable(AOwner: string; AccessMode: integer).

With the Owner property you can set the owner name, and with the SetOwnerOnTable method you can set or clear the owner name on the table.

Table 1-1 PDAC Access Modes


Code	Description
0	Requires an owner name for any access mode (no data encryption)
1	Permits read-only access without an owner name (no data encryption)
2	Requires an owner name for any access mode (with data encryption)
3	Permits read-only access without an owner name (with data encryption)

To access the Btrieve table, you should provide a valid owner name.

SQL Security

SQL/ODBC security is database security on the DDF level. There are no special methods in PDAC to set up SQL security. You should use external programs such as the Pervasive Control Center or any ODBC tool. See the Pervasive.SQL User's Guide for more information on the Pervasive Control Center. If the database has security, a dialog displays in which you enter the user name and password each time you open a table or connect to a TPvDatabase component. To verify if security is set up on the database, you can check the public property TPvDatabase.IsSecured.

Note
If the database has SQL security enabled, the Btrieve/Owner name security is ignored.