Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Security constraints on Database View (DB View)

Ariel Aharon
Giga Guru

Hi,

 

I have created a DB View combining metric_instance && sn_hr_core_case (HRSD modules).

We've granted read operation on the metric_instance table so that sn_hr_core.manager could read records.

 

But now I get this message when impersonating to test user with sn_hr_core.manager role:

ArielAharon_0-1670922338917.png

Even though both metric_instance && sn_hr_core_case has read access (I saw that metric_instance has no report_view operation, this might be it?) and I can access these tables separately, but the DB View is restricted for some reason.

 

Any suggestion?

 

1 REPLY 1

Ariel Aharon
Giga Guru

Bumping this up, still relevant.