We accidentally removed the ROLE_ADMINISTRATOR from the superuser. Now when we logged in as superuser, we cannot view anything. Is there any way to recover from it? We are running Jasper 6.3.0
Release : 4.2
Component : Service Operations Insight (SOI) Manager
# for superuser, userId =3
# for Role_Administrator, roleId = 1
Use the following SQL query to re-add the role.
insert into dbo.JIUserRole (roleId, userId) values (1,3)