Specifies an authentication string that is used to verify the application signature against the database signature for authenticated applications.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||No||No||No|
|Allowed to set temporarily?||Yes, with SET ANY PUBLIC OPTION||Yes (current connection only)||No|
This option only takes effect when you are using the OEM Edition of the SQL Anywhere database server that supports OEM authentication.
Authenticated applications must set the connection_authentication database option for every connection immediately after the connection is established. If the signature is verified, the connection is authenticated and has no restrictions on its activities beyond those imposed by the SQL privileges. If the signature is not verified, the connection is limited to those actions permitted by unauthenticated applications.
Set the connection_authentication option for the duration of only the current connection by using the TEMPORARY keyword. The following SQL statement authenticates the connection:
SET TEMPORARY OPTION connection_authentication = 'company = company-name; application = application-name; signature = application-signature';
The company-name and application-name must match the values specified by the database_authentication option. The application-signature is the application signature that you obtained from SAP.
If your company name has quotation marks, apostrophes, or other special characters, double them in the string for it to be accepted.
The following example specifies an authentication string that contains special characters:
SET TEMPORARY OPTION connection_authentication= 'Company = Joe''s Garage; Application = Joe''s Program; Signature = 0fa55157edb8e14d818e...';