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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » What's new in version 16.0 » SQL Anywhere new features


Administration enhancements

  • Databases restart after upgrades   By default, the database is now stopped and restarted after an upgrade. To stop the database after an upgrade instead of restarting, use the RESTART OFF clause of the ALTER DATABASE statement or the -nrs option of the Upgrade utility (dbupgrad). A database upgrade renames the transaction log once the upgrade completes successfully. See ALTER DATABASE statement and Upgrade utility (dbupgrad).

  • Change the owner of a table   You can now alter the owner of a table by using the ALTER TABLE statement. When altering a table owner, you have the options of preserving or dropping explicitly granted privileges and preserving or dropping foreign keys. See ALTER TABLE statement.

  • Dual control passwords   The change_password_dual_control login policy option requires two administrators to be involved in changing the password for a target user. The first user specifies the first part of a password, the second person specifies the second part. Dual control password changing prevents a password administrator from knowing the complete password of another user.

    The target user must have the change_password_dual_control option enabled in their login policy.

    The function specified by the verify_password_function database option is not called for users that have a login policy with the change_password_dual_control option enabled.