Executor: DBA privilege holder

You use DROP CONNECTION SECURITY to cancel the password character string restrictions. This operation returns the system to its status before the password character string restrictions were set.

Example

Cancel the password character string restrictions currently in effect:

 
DROP CONNECTION SECURITY FOR PASSWORD
 

Reference note

You cannot delete the restrictions individually (for example, you cannot cancel only the setting for the minimum number of bytes for a password).

Note

Canceling the password character string restrictions releases the password-invalid account lock state. As a result, any users who had been in this status and who should not be allowed to connect to HiRDB become able to connect. You should first check for the users in password-invalid account lock state.