DROP CONNECTION SECURITY (Delete the connection security facility)

Function

DROP CONNECTION SECURITY deletes security items related to the connection security facility.

Privileges

User with DBA privileges
Users with DBA privileges can execute DROP CONNECTION SECURITY definition statements.

Format

DROP CONNECTION SECURITY FOR security-object[, security-object]

security-object::={CONNECT|PASSWORD}

Operands

In security-object, CONNECT and PASSWORD can each be specified only once.

CONNECT
Specify this operand when deleting settings related to a consecutive certification failure limit.
PASSWORD
Specify this operand when deleting settings related to password character limit enhancement.

Notes

  1. If settings related to the consecutive certification failure limit are deleted, all users are released from the consecutive certification failure account lock state (the null value is assigned to the consecutive certification failure account lock date and time, and to the permitted number of consecutive certification failures in SQL_USERS).
  2. If settings related to the password character limit are deleted, all users are released from the password-invalid account lock state (the null value is assigned to the password-invalid account lock date and time of SQL_USERS).
  3. An undefined security object cannot be specified.
  4. An error may occur if an attempt is made to delete both CONNECT and PASSWORD when either CONNECT or PASSWORD, but not both, is defined. Any defined items that are specified as objects of deletion are not deleted.

Examples

  1. Delete settings related to password character limit enhancement.

    DROP CONNECTION SECURITY FOR PASSWORD