Resolving repository authentication issue if restrict access is enabled

Resolving repository authentication issue if restrict access is enabled.

Symptoms

User validation fails if the Db2® Data Management Console repository authentication is enabled.

Causes

The repository database is set to enable the option of 'Restrict access'.

[db2inst1@myTestServer ~]$ db2 get db cfg | grep -i restrict
Restrict access = YES

Resolving the problem

Grant the following privileges to the users of the repository database:

db2 "grant select on sysibm.sysdummy1 to user <username>"
db2 "grant usage on workload sysdefaultuserworkload to user <username>"
db2 "grant execute on package nullid.SQLC2O26 to user <username>"
db2 "grant execute on package nullid.SQLC2O27 to user <username>"
db2 "grant execute on package nullid.syssh100 to user <username>"
db2 "grant execute on package nullid.syssh200 to user <username>"