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.