Hello Krishna,
To go back and use the Super Admin user created during the installation, please follow these instruactions:
1. Stop DMC, make sure that there is no DMC processes running.
2. Edit the file dswebserver_override.properties under <DMC_install>/Config directory, and change the parameter auth:
from
auth=metadb
to
auth=superAdmin
3. Restart DMC.
If you don't remember the password for that user, please refer to the DMC manual at:
https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=administering-resetting-default-admin-user-passwordI hope that helps!
------------------------------
Cintia Ogura
------------------------------
Original Message:
Sent: Thu August 12, 2021 01:00 PM
From: Krishna Murakonda
Subject: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.
Hi Cintia,
Thanks for the detailed info . I remembered some roles were added to the console user (while changing from default 'admin') but couldn't recall what they are. In current situation, I'm unable to login to the DMC console to verify the same.
------------------------------
Krishna Murakonda
Original Message:
Sent: Wed August 11, 2021 09:32 AM
From: Cintia Ogura
Subject: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.
Hello Krishna,
Can you please check if you have assigned the user to the group access according to the DMC manual at:
https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=database-configure-user-role-mapping-settings
DMC needs the user to be part of one of the groups:
IBM Db2 Data Management Console provides four different types of methods of user role mapping namely Db2 Authorities, Db2 Groups, Db2 UDF and Db2 Roles. For each role mapping method, you can define three specific rules in the console for three roles in console, admin role, DBA role and user role. Select one of the four types of method of rules to be configured.
The Database Administrator authorities was introduced in DMC V3.1.5.
I hope that helps!
------------------------------
Cintia Ogura
Original Message:
Sent: Tue August 10, 2021 04:48 PM
From: Krishna Murakonda
Subject: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.
The DMC Console login user was replaced with default "admin" few weeks back and was working so far. But, all of sudden today it throws an exception below. Appreciate any clue in resolving the issue.
HWCSEC0005E: Check role failed, Unauthorized Access!
Authentication pass but the login user is configured neither as administrator nor user role.
The repo DB is up and running the login user has the dbadm privileges
Also, tried to restarted DMC but of no luck.
------------------------------
Krishna Murakonda
------------------------------
#Db2