You can upgrade an authenticated database by creating the authenticate.sql file in the %SQLANY16%/scripts directory before upgrading or rebuilding the database. The file is run by the CREATE DATABASE and ALTER DATABASE UPGRADE statements, dbupgrad and dbunload utilities, and the Upgrade Database Wizard.
To set PUBLIC options, you must have the SET ANY PUBLIC OPTION system privilege
It is recommended that you make backup copies of your database files.
Context and remarks
The only way to preserve authentication information when upgrading or rebuilding a database is to store the authentication statement in the file authenticate.sql.
Create a file named authenticate.sql in the %SQLANY16%\scripts directory.
Add the following contents to the file:
SET OPTION PUBLIC.database_authentication = 'authentication-statement' go
go must appear in the file; otherwise, the statement is ignored.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|