DOMINO AND DB2

Granting SETSESSIONUSER privilege to the Domino server user
Complete this procedure after you successfully complete the procedure to enable the IBM® Lotus® Domino® server to communicate with the IBM® DB2 Universal Database™ Enterprise Server Edition server. You must grant SETSESSIONUSER privilege to the Domino server user in order to execute Query views.

For information about creating DB2 user accounts and granting privileges in DB2, see the DB2 Information Center.

1. Ensure that the Domino server user is a member of the group DB2DOM (SYSCTRL_GROUP).

2. Ensure that you have at least one other DB2 user account that has SYSADM authority.

3. Connect to the DB2 database using the User ID that has SYSADM authority.

4. Grant SECADM authority to the Domino server ID.

5. Connect to the DB2 database using the Domino server ID.

6. Grant SETSESSIONUSER privilege to the group, DB2DOM.

Example

Make the following assumptions:


You can perform these steps to set up the correct privileges:

1. Type this command:


2. When prompted, specify the password. db2admin now has SYSADM authority.

3. Type this command:


4. Type this command:
5. When prompted, specify the password. DominoServerUserID now has SECADM authority.

6. Type this command:


If you are working with a Microsoft® Windows® platform, return to the roadmap topic Installing Domino and DB2 on Microsoft Windows platforms.

If you are working on an IBM® AIX® platform, return to the roadmap topic Installing Domino and DB2 on IBM AIX and Linux platforms.

Related topics