Sysadmin Credential

Identity Governance & Administration (IGA)
1

Hi,
We are having an issue logging in the user ‘sysadmin’. Credentials are correct as it is an auto filled. We tried changing or resetting the password manually, but it is not working. Additionally, we also tried to change the password in the DB itself but for some reason it is also not working. This also applies to all sample users that we are using for testing.

image
image800×464 58.8 KB

image
image1275×804 54.5 KB

UPDATE LOGIN
SET
PASSWORD = <Generated 256SHA>,
FIRST_TIME_LOGIN = ‘N’,
AUTH_FAIL_COUNT = 0,
CHALLENGE_RESPONSE_FAIL_COUNT = 0,
OTP_FAIL_COUNT = 0,
LOCK_MARKER = ‘NOT_LOCKED’,
IS_ACTIVE = ‘Y’,
STATUS = NULL,
PWD_CHANGE_COUNT = 0
WHERE LOWERCASE_LOGIN = ‘sysadmin’ AND MANAGED_SYS_ID = ‘0’;

2

Hello Pamela,

I am checking with my team and will get back to you shortly.

Thanks,
Ameet

1 Like
3

Hello Pamela,

Resetting the password field directly in the database is not recommended and can lead to unintended issues. We prefer you follow the documented procedure for changing the admin password as outlined in this link: https://docs.openiam.com/docs-4.2.1.13/admin/16-admin-pswd-change

This method ensures the password is updated correctly and securely within the application.

Thanks,
Ameet

1 Like
4

Thank you, Ameet. We’ll take note of this.