Db2 On Premise and Cloud

Expand all | Collapse all

DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.

  • 1.  DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.

    IBM Select
    Posted Tue August 10, 2021 04:48 PM
    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
    ------------------------------


  • 2.  RE: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.

    Posted Tue August 10, 2021 11:26 PM

    Hi Krishna,

    Pls check  authentication user password did not get expired..

    Kind Regards

    Prashant Shivmath
    Mobile : +91-9892691478
    Email : prashant.shivmath@in.ibm.com


    "Krishna Murakonda via IBM Community" ---11-08-2021 02:18:21---The DMC Console login user was replaced with default "admin" few weeks back and was working so far.






  • 3.  RE: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.

    IBM Select
    Posted Wed August 11, 2021 12:51 AM
    Hi Prashant,

    Authentication user password is valid and we are able to connect to repo DB with the user credentials. 
    The DMC logon error also confirm the same i.e. highlighted below 

    HWCSEC0005E: Check role failed, Unauthorized Access!
    Authentication pass but the login user is configured neither as administrator nor user role.

    ------------------------------
    Krishna Murakonda
    ------------------------------



  • 4.  RE: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.

    Posted Wed August 11, 2021 01:25 AM

    Hi Krishna,

    Please check the Monitor.0 log file what error it is showing for further investigation, Any changes done in DBM DB configuration file recently or any permission got revoked.. We get this error When our DB repository instance password get expire and we set to  old password it works fine..

    Prashant Shivmath
    Mobile : +91-9892691478
    Email : prashant.shivmath@in.ibm.com


    "Krishna Murakonda via IBM Community" ---11-08-2021 10:24:17---Hi Prashant, Authentication user password is valid and we are able to connect to repo DB with the us






  • 5.  RE: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.

    Posted Wed August 11, 2021 09:32 AM
    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
    ------------------------------



  • 6.  RE: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.

    IBM Select
    Posted Thu August 12, 2021 01:01 PM

    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
    ------------------------------



  • 7.  RE: DMC Login error - HWCSEC0005E: Check role failed,Unauthorized Access! Authentication pass but the login user is configured neither as administrator nor user role.

    Posted Thu August 12, 2021 02:37 PM
    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-password

    I hope that helps!

    ------------------------------
    Cintia Ogura
    ------------------------------