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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|