DROP LDAP SERVER statement

Drops an LDAP server configuration object.

Syntax

DROP LDAP SERVER ldapua-server-name
[ WITH DROP ALL REFERENCES ]
[ WITH SUSPEND ]

Parameters

WITH DROP ALL REFERENCES clause
Specify the DROP ALL REFERENCES clause to drop an LDAP server configuration object that is referenced from a login policy.
WITH SUSPEND clause
Specify the WITH SUSPEND clause to drop an LDAP server configuration object that is in a READY or ACTIVE state.

Remarks

This statement removes the LDAP server configuration object from the SYSLDAPSERVER system view after checking that the LDAP server configuration object is not in the READY or ACTIVE state. The statement fails when the state is READY or ACTIVE to ensure that the LDAP server is not in active use. To override this check, specify the WITH SUSPEND clause.

By default, a reference to the LDAP server configuration object in a login policy also causes this statement to fail. To remove an LDAP server configuration object that is referenced in a login policy, add the DROP ALL REFERENCES clause. Adding DROP ALL REFERENCES does not remove the reference from the login policy; it allows you to drop the configuration object when there are references. You must still remove the reference to the LDAP server configuration object from the login policy.

Privileges

You must have the MANAGE ANY LDAP SERVER system privilege.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following example suspends an LDAP server configuration object named apps_primary that is referenced in a login policy, and then drops it.

DROP LDAP SERVER apps_primary WITH DROP ALL REFERENCES WITH SUSPEND;