GRC Admin account is inactive. Please contact your system administrator GRC admin login issue

Dear Folks,

Recently, one of our customer raised issue about he was not able to execute GRC programs. When we tried to login with admin user and failed with  below error.

Your account is inactive. Please contact your system administrator."

We tried to reset the admin user password using below ML. But it wasn't worked. Tried with Upper/Lower case letters. Still not worked.

EGRCC/EGRCM863 Onwards On Weblogic/Tomcat: Admin User Password Reset Script. (Doc ID 1359078.1)

We followed up with oracle and came up with below solution.

Steps to reset admin password of GRC

----------------------------------------

1) Log all users off GRC
2) Take backup of GRC_SEC_USER table or grc schema
3) Run in GRC schema.

update GRC_SEC_USER
set password='*****',      <password as per your requirement>
change_password = 0,
status=40,
failed_login_attempts=0
where name = 'admin' and id= 1; If only one row updates, Commit;

4) Login in as admin/<password> and change password for admin in users screen.

#################

SQL> sho user

USER is "GRCUSER"

SQL> create table GRC_SEC_USER_bkp as select * from GRC_SEC_USER;

Table created.

SQL> update GRC_SEC_USER

set password='*******',

change_password = 0,

status=40,

failed_login_attempts=0

where name = 'admin' and id= 1;  2  3  4  5  6

1 row updated.

SQL> commit;

Commit complete.

Thanks.