Set a dual control password or change the first or last part of a dual control password. This feature prevents an administrator from knowing a user's complete password.
You must have the CHANGE PASSWORD system privilege.
The target user must have the change_password_dual_control option enabled in their login policy.
Context and remarks
Another administrator must change the other part of the password. The user combines the two password parts and uses this combined password to connect to the database.
Password parts are case-sensitive and they cannot:
Connect to the database.
An administrator executes the following statement to set the first part of the dual control password, and then communicates password-part1 to the user:
ALTER USER user-name IDENTIFIED FIRST BY password-part1;
Another administrator executes the following statement to set the second part of the dual control password, and then communicates password-part2 to the user.
ALTER USER user-name IDENTIFIED LAST BY password-part2;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|