Skip to main content

How to set up users who only need security on DB2 locations

  • February 15, 2013
  • 0 replies
  • 0 views

Problem:

Customer wants to set up a central XDB Server for all users to use to connect to the DB2 location but they don't want to add all the userid's and passwords to this machine.How to do this.

Resolution:

The easy way is as follows:

Here's the easiest answer can think of:

1) Client side security on

2) Server side security off

3) User created, no password, password not required (as in the following)

CREATE USER MFIREC

    TYPE SUPERUSER

    PASSWORD "" REQUIRED NO;

Old KB# 2965

#MFDS
#EnterpriseDeveloper