Pervasive.SQL Database Mode and Security
The DataFlex Pervasive.SQL Driver can be configured to operate in database mode or in non-database mode. When running in database mode, Pervasive.SQL tables are located by specifying a Pervasive.SQL database name. In non-database mode, tables are located by specifying paths to the physical data files.
Database mode can only be used when running on Pervasive.SQL V8.5 or later.
When running in database mode, it is possible to access Pervasive.SQL secured databases. One of the main advantages of secured databases is that users no longer need operating system access rights to access Pervasive.SQL data files. Instead, all authentication and authorization are handled by the Pervasive transactional database engine.
When using secured databases, access rights can be defined for individual users and tables. Users and access rights are defined in the Pervasive.SQL meta database and are independent of operating system access rights.
When operating in database mode, the driver can also concurrently access tables in more than one database, possibly on different servers.
Related Documentation
- Pervasive.SQL Database Concepts
- Using Database Access with the Driver
- Conversion in Database Mode
- Migrating to Secured Databases
- Security in Pervasive.SQL Prior to V8.5