Database Security

Advantage Concepts

  Previous topic Next topic  

Database security is essential for controlling access to the files in your database. If database security is not present, there is little or no control over whom can update data, delete files, and/or possibly corrupt data in the database. The Advantage Database Server provides two methods of database security for free connections:

Check Rights: Checking the user's network access rights before opening files for that user.
Ignore Rights: Ignore Rights: Allowing access to the database via an Advantage application only. Beginning with version 10.0, the client no longer performs rights checking by default. The default behavior is to use “Ignore Rights” regardless of the setting provided by the application. The pre version 10.0 behavior can be restored with a call to AdsSetRightsChecking.

The Advantage Database Server provides User Account database security for database connections. See the Flexible User Access Control section in Advantage Data Dictionary for more information.

Database security for Free Connections is specified via:

The TAdsTable/TAdsQuery.TAdsTableOptions.AdsRightsCheck value with the Advantage TDataSet Descendant.
The AdsOpenTable API with the Advantage Client Engine API
The RightsChecking value in the ODBC registry entry section for the Advantage ODBC Driver.
The ADSPROP_INIT_SECURITY_MODE property in Initialization Properties or the "SecurityMode" provider-specific Connection parameter with the Advantage OLE DB Provider.
The AX_RightsCheck function with the Advantage CA-Visual Objects RDD.

Linux users, see Linux Rights Checking.