Unable to view few of the fields data in a database view table

[Manisha30]

HI Team,

We have an issue where some users are unable to view few fields data in the database view table and it is showing blank.

Can someone please suggest what could be the probable cause for this?

Thanks in Advance!!!
Manisha

[Brad Bowman]

The most likely cause is ACL(s) on the field(s).  You can confirm this by having the affected users view a list of records on one table and see if the same fields are blank or redacted.

[SK Chand Basha]

Hi @Manisha30 

Cause due to ACL

Use access analyzer module to test the fields for the particular user. 

https://www.servicenow.com/community/platform-privacy-security-blog/vancouver-release-customers-gain...

Mark it Helpful and Accept Solution!! If this helps you to understand. 

[Sumanth16]

Hi @Manisha30 ,

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. By default they are only visible to admins.

Please mark this response as correct or helpful if it assisted you with your question.

Thanks & Regards,
Sumanth Meda