Sonarqube 9.9lts not show project on dashboard when restore specific table in DB

Must-share information (formatted with Markdown):

  • We using Sonarqube 9.9 LTS, We have an incident when apply Bulk Apply Permission Template all roles permission custom had been lost, now we want to restore only user_roles and group_roles but we face an issue when importing only specific tables is user_roles and group_roles, on Sonarqube dashboard not showing Project but in user account project appear normal.

  • We using PostgreSQL version 13

=> Can’t anyone face the same issue, what can I do in this situation, or What I missing any other Table when importing?


You should reapply the permission templates through the UI.

We do not advise direct manipulation of the database. If you feel you must restore this from backup, then you should restore the entire DB.