Online Documentation for SQL Manager for DB2

Trusted Contexts


Trusted Context is the object that allows one to define trusted connection at the current server. The user name associated with the trusted connection can then be switched without the database server having to fully authenticate the new name. Use trusted connections to preserve the identity records of clients that are connecting to a DB2 database through your applications; trusted connections can provide a more secure environment by granting access based on the identity of those users.

 

 

Creating Trusted Contexts

 

To create a new trusted context:

Hint: To create a new trusted context, you can also right-click the Trusted Contexts node of the DB Explorer tree and select the New Trusted Context... context menu item.

 

 

Editing Trusted Contexts

 

To edit an existing trusted context:

  • select the trusted context for editing in the DB Explorer tree (type the first letters of the trusted context name for quick search);
  • right-click the object and select the Edit Trusted Context <trusted context_name>... context menu item, or simply double-click the trusted context;
  • edit trusted context definition using the appropriate tabs of Trusted Context Editor.

 

Dropping Trusted Contexts

 

To drop a trusted context:

  • select the trusted context to drop in the DB Explorer tree;
  • right-click the object and select the Drop Trusted Context <trusted context_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new trusted context;

Ctrl+O to edit the selected trusted context;

Shift+Del to drop the object from the database.