How to allow full table access to non-admin user.

[ralph_campbell]

Hi,

We are trying to pull request information via the REST table api.

https://xxxxxxx.service-now.com/api/now/table/sc_request?sysparm_query=sys_updated_on%3C2017-07-26+1...

We have created and ACL for the user/role with full access, but some of the fields are not being returned. For example the "Number" field is missing when the query is run by a non-admin. When the query is run by a admin user all the fields are returned.   We need assistance in configuring the security/ACL for the sc_request table.

Thanks

Ralph

[shruti_tyagi]

Hi Ralph,

Easiest way to check is, login from the non-admin user open sc_request list and check the fields that are not visible to the user. I am guessing from your api you just reading the records.

Now go back to admin user and open sc_request list again. Right click header and do configure security rules. Just focus in read acls. These are the only acls you will be interested in (insert you instance name):

https://<instance_name>.service-now.com/sys_security_acl_list.do?sysparm_query=operation%3Dread%5Ena...

OOB users with ITIL or catalog role have access on all fields in sc_request table. And than we have these 4 field level read access for requested_date, request_state, stage, requested_for. If you want to give access to non roled users what you would need to do is disable these 4 acls field acls and look if you have more custom ones similar to this. Add sc_request.* acl and add role you want give access to.

Log back in with that user and open list again to make sure he can see all fields now

Thanks

Shruti

If the reply was informational, please like, mark as helpful or mark as correct!

[shivanipatel]

Ralph,

We are glad you took advantage of the ServiceNow Community to learn more and to get your questions answered. The Customer Experience Team is working hard to ensure that the Community experience is most optimal for our customers.

If you feel that your question was answered, we would greatly appreciate if you could mark the appropriate thread as "Correct Answer". This allows other customers to learn from your thread and improves the ServiceNow Community experience.

If you are viewing this from the Community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thanks,

Shivani Patel