Database View access permissions

[gkr]

Dear All,

I have a database view which joins 3 tables. I am using Rest API to call the DB   View.

All works fine when I use admin account to call the DB view using Rest API.

We have also have a dedicated API user account. But we get the below error when we use this account. Is there any role permissions this account is missing. If yes, how we can add the missing role permissions?

{"error":{"message":"User Not Authorized","detail":"User is unauthorized to access table: u_vw_clients"},"status":"failure"}

Any help is greatly appreciated.

[dravvyramlochun]

Hello gkr

Maybe the following is helpful to you:

Create a read ACL directly on the database view table to allow non-admin users to view database view records.

1. Type Access Control in the navigation filter.
2. Select the Access Control (ACL) module.
3. Select the New action at the top of the list.
4. Under Operation, select Read, and under Name, select the name of the database view i.e. Incident SLA
5. Add the required roles needed to access the database view and click Submit.

Reference:

ServiceNow KB: Database View records require read ACLs created for non-admin users after upgrade to ...

Use a Read ACL on Database Views when Reporting in Fuji

ServiceNow KB: Determining if a user has permissions to create, read, and write on an extended table... Database view access for a new role.

Database view access for a new role.

[gkr]

Perfect. Works! Dravvy, your reply is much appreciated.

[dravvyramlochun]

Hello gkr

I am glad it worked.

Please mark it as correct/answered so that it does not appear in the unanswered list.