How To Assign 'ROLE_SUPERUSER' To Specific User

Requirement

Is there a way to assign 'ROLE_SUPERUSER' to 'Admin' user without logging to TIBCO JasperReports® Server as 'superuser' and giving this role?

Solution

By default 'Admin' user has two roles: 'ROLE_ADMINISTRATOR' & 'ROLE_USER'. And only 'superuser' can add ROLE_SUPERUSER to it through user interface:

One way how to achieve this could be adding necessary data to repository DB, in 'jiuserrole' table (however, you have to have proper DB user id/password for doing this).

             Please note, that we DO NOT recommend to do any manual actions on repository DB due to it may break you DB at all!

Do a backup of your repository DB before doing next steps!

1. Find the 'id' for 'Admin' user in table 'jiuser':

   

2. Find the 'id' for ROLE_SUPERUSER in table 'jirole':

   

3. Insert these values (it will add the ROLE_SUPERUSER to 'Admin' user) in table 'jiuserrole':

   

4. Re-login to JasperReports® Server as 'Admin' user and check:

   

References

Why A User With ROLE_SUPERUSER Assignment Does Not Seem To Have Superuser Privileges

VO - 20190403, case #01735011