Access Analyzer shows 'read' access but User not able to view the list report

vikram_77
Giga Contributor

Hi,

 

I  have created Dashboard on 'purchase order line'  table, and shared it with user(John Diesel) having 'sn_shop.shopper' .  This dashboard has bar chart and list type report. Use able to see the bar chart but can't see the list report. It shows 'No Records to Display'  shown in below screenshot.

vikram_77_0-1754740126425.png

 

Then I went throw some community post, and Finally concluded that user should have at least read on the table.  As this user can't view the records on this table. Then ran access analyzer for this user and it shows read/write/report_on access pass. shown in below screenshot.

vikram_77_1-1754740244861.png

 

I am now confused what is issue with access analyzer.  why it is showing user has read/write access to this table.

 

POV :This is in PDI

 

Thanks,

Vicky

5 REPLIES 5

TamoghnaB
Tera Expert

Hi Vikram,

 

Read ACL must be configured for view access to any table data.

Apart from that, there is one more thing that puts read restriction in Business Rule. Please check if that table has any "Query" type Business Rule. This type of business rule runs each time you try viewing data on a table and if the condition mentioned in the BR does not match, then it will simply not display any record and also it will not indicate any error message. Please check and let me know if there is any such rules.

Thanks!

 

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

There is no query BR on the this table.

 

But the ask is why in access analyzer  shows user has read/write overall access, as it shows pass. Please refer the screenshot.

 

Thanks,

Vikcy

vikram_77
Giga Contributor

any thoughts @GlideFather ,

@Dr Atul G- LNG 

 

I am still in confusion about this.

 

Thanks,

Vicky