What is the best way to grant access to "Database View"?

[nobutomo]

I'd like to let some IT folks to use the "Database View" to create reports which refer multiple tables.

I'm not sure how I should grant ACL to them.

Is there any simple and easy way to do it?

[gyedwab]

Hi Nobutomo,

Database views are very complex to use, and they can break integrations if they're not defined properly. They make changes to the database, so I wouldn't recommend giving them access to users directly -- it's typically an admin-level change.

If you want to give self-service access to refer to multiple tables, you can use a tool like Explore Analytics. That way, users can create their own reports against multiple tables without having to make admin- level changes -- e.g. this one that combines changes, incidents, and knowledge articles: https://my.exploreanalytics.com/pub/view/6dd64c8842334988a427847e490375e3

[nobutomo]

Hi Guy,

Thank you for your comments. It seems great but I don't think we can pay for this service at this moment... Do you know any way to manage reports which can view multiple tables?

[gyedwab]

Hi Nobutomo,

I'm not sure how you'd resolve the ACL issue, and it would still be a high risk approach. The other option within ServiceNow to explore is Custom Charts -- they require javascript, but there's not as much risk to the system if they go wrong.

Sorry I couldn't help more.

[mike_bush]

Guy's comments are not helpful, he is doing his "sales pitch" and as for "views make changes to the database" - just not true.

They have a VERY valid place in the system - in particular allowing metrics to be viewed with their "base" table.

We still need an answer - how do we present a view to SOME users rather than ALL - an ACL would be my guess?