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
- security-object::= {CONNECT | PASSWORD}
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
- 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).
- 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).
- An undefined security object cannot be specified.
- 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
- Delete settings related to password character limit enhancement.
DROP CONNECTION SECURITY FOR PASSWORD