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
| 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.