Online Documentation for SQL Manager for DB2

User Mappings

A User Mapping is an association between the authorization under which a user connects to a federated server and the authorization under which the user connects to a data source.

Creating User Mappings

To create a new user mapping:

• select the Database | New Object... main menu item;
• select User Mapping in the Create New Object dialog;
• edit user mapping properties using the appropriate tabs of User Mapping Editor.

Hint: To create a new user mapping, you can also right-click the User Mappings node of the DB Explorer tree and select the New User Mapping... context menu item.

Editing User Mappings

To edit an existing user mapping:

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

Dropping User Mappings

To drop a user mapping:

• select the user mapping to drop in the DB Explorer tree;
• right-click the object and select the Drop User Mapping <user_mapping_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 user mapping;

Ctrl+O to edit the selected user mapping;

Shift+Del to drop the object from the database.