This option only takes effect when you are using the OEM Edition of the SQL Anywhere database server.
When a database is authenticated, only connections that specify the correct authentication signature can perform operations
on the database. Connections that are not authenticated operate in read-only mode. To use authenticated databases, use the
OEM Edition of SQL Anywhere.
To authenticate a database, set the database_authentication option for the database:
The company-name and application-name arguments are the values you supplied to Sybase when obtaining your signature, and database-signature is the database signature that you received from Sybase.
If your company name has quotation marks, apostrophes, or other special characters, double them in the string for it to be
When the database server loads an authenticated database, it displays a message in the database server messages window describing
the authenticated company and application. You can check that this message is present to verify that the database_authentication
option has taken effect. The message has the following form:
This database is licensed for use with:
You can store the authentication statement in a SQL script file to avoid having to type in the long signature repeatedly.
If you store the authentication statement in the file %SQLANY16%\scripts\authenticate.sql, it is applied whenever you create, rebuild, or upgrade a database.