User can't see values in database view.

[Dotychczas]

Hi Experts,

I've created database view connecting services and kb articles. It works fine for me but when other user entering this view he can filter out records with empty number(from kb) but records that are left are showing no value which is not a case when I'm logged as admin. I've checked ACLs and there is one read acl that I disabled to see if that is the issue but it didn't help. I run debbug of security rules and it showed nothing. The issue is only with KB articles causes data from service table is visible. I've also checked on query business rules but nothing is blocking the view. Is there any thing that I missed?

[suvro]

Check the knowledge base of the knowledge articles is there any user criteria defined for canRead. That may be hindering the view

[Dotychczas · Accepted solution]

I've solved it. When creating Database view you need to create ACLs for that new table which is not very intuitive as there is no option to configure ACLs on database table view. After I've added read ACLs to freshly created database view, visibility of KB records was restored.