You can authenticate a database using the SET OPTION statement.
You must have the SET ANY SYSTEM OPTION system privilege to set this option.
Set the database_authentication option for the database by using the following SQL authentication statement:
SET OPTION PUBLIC.database_authentication='company=company-name; application=application-name; signature=database-signature';
Line breaks have been added to the syntax example to improve readability. However, the syntax should be executed without line breaks and without spaces between the equal sign and semicolons.
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.
Restart the database for the option to take effect.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|