Skip to main content

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.

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


Terms & ConditionsCookie settings