The non-admin users are not able to access to a table


Description

The non-admin users are not able to access to a table.

 

Release or Environment

All releases. This would be applied to both OOB tables and custom tables.

Cause

The issue should be caused by either or two of the following reasons:

1. There is no any base system STAR (*) table level read ACL with record Type for the affected table.

2. There is no any read ACL with its name matches the table name for the affected table.

According to the documentation https://docs.servicenow.com/csh?topicname=acl-rule-types.html&version=latest, the user must first pass the table ACL rule. Since the base system includes STAR (*) table ACL rules that match every table, the user must always pass at least one table ACL rule. The base system provides additional table ACL rules to control access to specific tables. 

Table ACL rules are processed in the following order: 
1. Match the table name. For example, incident. 
2. Match the parent table name. For example, task. 
3. Match any table name (*). For example, *. 

If a user fails all table ACL rules, the user cannot access the fields in any table. If a user passes a table ACL rule, the system then evaluates the field ACL rules.

 

Resolution

The issue can be resolved in the following ways:

  1. Create at least one base system STAR (*) table level read ACL with record Type for the affected table.
  2. Create at least one read ACL with its name matches the table name for the affected table.

 

Additional Information

Please refer to the documentation https://docs.servicenow.com/csh?topicname=acl-rule-types.html&version=latest to get a better understanding about how ACLs are working on a table.