Question

Quick report and Unpublish option

  • 20 March 2023
  • 1 reply
  • 74 views

Userlevel 4
Badge +8

When a quick report is published, it grants the Projection to all available permission sets.

THere is no easy way to “Unpublish” the quick report.

I cannot find any option to select a Projection, and then remove access for this projection for several permission sets at the same time. This would be a most helpful feature.

My customer (currently 21R2) has hundreds of permission sets, to go in to every single permission set to remove the grant, would take a very long time.


1 reply

Userlevel 4
Badge +7

Hi @Malin Norgren ,

This would not be the ideal solution, but you might be able to use below query in the database level and delete the records from there.

select * from PRES_OBJECT_GRANT_TAB where po_id = ‘repQUICK_REPORT<report_projecton_no>’

report_projecton_no can be selected from Quick report detail.
 

report_projecton_no


Ex -  select * from PRES_OBJECT_GRANT_TAB where po_id = ‘repQUICK_REPORT583155’;

Thanks,
Avindu

Reply