Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

connection_authentication option

Specifies an authentication string that is used to verify the application signature against the database signature for authenticated applications.

Allowed values

String

Default

Empty string

Scope
  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
Remarks

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.

Example

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...';