how can i edit Security rules for the database views?

[ashwanikumar]

Hi All,

I created a database view using two tables. Teams with role 'abc' can see both the tables in list view and can also open the form.

There are some fields which are restricted only for the admins (only field level ACLs in both the tables).

When the teams with the same role 'abc' are trying to access Database view of the tables. System is showing following message:

Security constraints prevent access to requested page

Where can I see acls for the database views and how can i edit them??

Thanks,

KUMAR

[Rajesh Mushke]

Hey Kumar,

Maybe the following is helpful to you:

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

Type Access Control in the navigation filter.

Select the Access Control (ACL) module.

Select the New action at the top of the list.

Under Operation, select Read, and under Name, select the name of the database view i.e. Incident SLA

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... unknown

Database view access for a new role.

[Rajesh Mushke]

hey ashwanikumar

any update on this, let me know if you need more

can you please close this this read, if it resolves your issue, then only this will be helpful for other community users.

[Rajesh Mushke]

If I have answered to your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

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