ACL on Database View

[Sowmya Lagadapa]

Hi,

I would like to know if we can write ACL's on database view. I am trying to give write access to one of the groups to a field from 'awa_agent_presence_capacity' database view which is not working.

My Script in ACL :
answer = false;
if(gs.getUser().isMemberOf('my custom group')){
answer = true;
}

Can someone help me on this?

TIA

[Anurag Tripathi]

Hi,

You cannot write ACL on DB view. The ALC on the tables part of  view will be honored.

If you can add the ACL on the table then that would be the most straightforward solution.

check this out, similar discussion here

What is the best way to grant access to "Database View"? - IT Service Management - Question - Servic...

-Anurag

[Kieran Anson]

One of the limitations of DB views is the inability to edit the row. They're purely for reporting and data visibility purposes.

Limitations

• Database views cannot be created on tables that participate in table rotation.
• It is not possible to edit data within a database view.
• In a clone request, database view tables cannot be added as a data preserver.

[Voona Rohila]

Hi Sowmya, Check the limitations of database view

https://docs.servicenow.com/bundle/paris-platform-administration/page/use/reporting/concept/c_Databa...