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
- 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.
DROP TRUSTED CONTEXT cntx1;This example fails if cntx1 is not the name of a trusted-context object of the current database server instance.