How to recover Qlik NPrinting Administrator account privileges

[Eduardo_Monteiro]

This article assumes you understand:

• How to use pgAdmin
• Have postgres credentials for Qlik NPrinting
• How to connect to the Qlik NPrinting database

* Modifying the Qlik NPrinting Repository will void the Support Agreement! Changes to the database should be performed by the Qlik NPrinting services only or through the use of supported API calls.

Overview

If, for some reason, you lost the Administrator role for your Qlik NPrinting Admin account and you are unable to change settings in the Web Console, you can follow this article to restore administrative access to the target account.

Symptoms

You are unable to edit/change any Administrative settings.

Resolution

You can force insert/update the user in the database with the administrator role id.

The first step is to connect to the database using pgAdmin.

• Refer to How to Connect to the PostgreSQL Database used for... - Qlik Community - 1714888

The second step is to identify the administrator role id using pgAdmin.

• Open pgAdmin
• Connect to the Qlik NPrinting database
• Navigate to: Databases>nprinting>Schemas>public>Tables>role
• Right-click the table "role" and select "All Rows".

•  Take note of the administrator "id" (green marked in the image above).

In my test environment, the administrator role equals "6b800774-db4f-4b5e-a975-24e5b86b5ece".

The third step is to identify the user role ID using pgAdmin.

• Open pgAdmin
• Connect to the Qlik NPrinting database
• Navigate to: Databases>nprinting>Schemas>public>Tables>usr
• Right-click the table "usr" and select "All Rows".

 

• Take note of the administrator "id" (green marked in the image above).

In my test environment, the administrator role equals "1628ad97-75af-4cb3-897f-da1cb07777e5".

The fourth step is to update the "role_recipient" table.

• Open pgAdmin
• Connect to the Qlik NPrinting database
• Open the Query tool by navigating to the top menu "Tools>Query Tool".

Use the following command line, replacing the information you previously retrieved.

Insert into public.role_recipient VALUES ('user role id','administrator role id');

In my scenario, it will be:

Insert into public.role_recipient VALUES ('1628ad97-75af-4cb3-897f-da1cb07777e5','6b800774-db4f-4b5e-a975-24e5b86b5ece');

Click "Execute script" or press F5.

Go back to Web Console and refresh the page. The target user should have Admin privileges. 

Environment

• Qlik NPrinting May 2023 IR to February 2025 SR4
• pgAdmin 9.13

[steveshaw]

Helpful. Thank you @Eduardo_Monteiro 

[SergioProba]

Thanks for sharing this article.

[priscilarubim]

Thanks for sharing!!!

[TonySapede]

Nice one. Thanks!