DROP TRUSTED CONTEXT statement

Use the DROP TRUSTED CONTEXT statement to destroy a trusted-context object.

This statement is the HCL OneDB™ extension to the ANSI/ISO standard for SQL. You must hold the database security administrator (DBSECADM) role to drop a trusted context.

Syntax


1  DROP TRUSTED CONTEXT   context
Element Description Restrictions Syntax
context Trusted-context object to destroy. Must exist on the current HCL OneDB database server instance. Identifier

Usage

When the DROP TRUSTED CONTEXT statement executes successfully, the specified trusted context object is destroyed. All references to the context will be deleted from these tables in the sysuser database of the HCL OneDB database server instance:
  • systrustedcontext
  • systcxattributes
  • systcxusers.

If you drop the trusted context while trusted connections for this context are active, those connections remain trusted until they terminate, or until the next reuse attempt. If an attempt is made to switch the user on these trusted connections, however, an error is returned.

The following example of a DROP TRUSTED CONTEXT statement destroys the cntx1 trusted-context object:
DROP TRUSTED CONTEXT cntx1;
This example fails if cntx1 is not the name of a trusted-context object of the current database server instance.