CABI/Jaspersoft - accidently removed ROLE_ADMINISTRATOR from superuser

book

Article ID: 196447

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction

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

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

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