Tip of the day: ACLs for Database Views

mitzaka
Mega Guru

‎07-05-2017 07:50 AM

Hey guys,

Hope it's not a spam, but I'll try to post interesting things as I come upon them. Sorry if you already know them!

So something I know, but had forgotten before I crashed into it today - when you try to create your own database view (or a JOIN, how we would call it in relational database), and combine two tables into one. Once you create the database view, then in order for non-admins to see it in reports, widgets, portal pages, etc - you need to create a 'read' ACL on that database view.

More info here: http://wiki.servicenow.com/index.php?title=Database_Views#gsc.tab=0

Section 1.1

Cheers and have a good evening!

0 Helpfuls
  • 6,489 Views
1 REPLY 1

Sharique Azim
Kilo Sage

‎07-05-2017 07:57 AM

Hi,



Adding to what you have said, the Read ACL should also be available   to the users on the individual tables which you are   also.


So,   you are adding read acls roles to three tables, database view/joins   ,table(two or more) joined.. That makes it atleast three.


0 Helpfuls