vtb table access

MD7
Kilo Contributor

‎02-15-2020 12:29 PM

I would like to provide a user access to Servicenow tables vtb_card and vtb_lane.
Reason: these tables contains meta information about cards / ptasks which he needs to produce reports and dashboards. Currently when he is trying to create a report he is not able to do so and getting an error:  Number of rows removed from this list by Security constraints: 20

I've tried with multiple roles but its not helping. 

Can somebody please guide me how can I resolve this issue ?

Thanks in advance !!

 

Labels:
0 Helpfuls
  • 1,259 Views
2 REPLIES 2

Brian Bouchard
Mega Sage

‎02-15-2020 12:51 PM

Rather than trying a variety of roles, you should start by reviewing the ACLs for the table to see which roles have access to read.  In our instance (I believe this is OOB), for vtb_card there is an advanced read rule on all fields with the following script:

answer = new VTBBoardSecurity().canAccess(current.board);

This means there is scripted logic determining who has access.  If you look at the VTBoardSecurity script include, you'll be able to see the criteria being used.

I believe you could create a new role and add logic to that script include to add a check that says " OR the current user has role XYZ"  to give them that additional capability.  You would need to do similar review of the other table(s) ACLs to determine how to best grant access.

 

MD7
Kilo Contributor

‎02-15-2020 01:15 PM

Hi Brian,

Thanks for your quick reply...

Yes you are correct and this is indeed OOB. The user is member of the boards and can access. However, he is still not able to access the vtb_card or vtb_lane table whilst creating a report.

As you suggested I'll talk to the developers in the team for implementing the logic.

 

Regards,

Mohit

0 Helpfuls