Report on Database view

[GBS]

I have created a database view that combines an incident table and a metrics definition table, and I have created a report on the database view. User was able to access the data from the list view but was unable to view the data on  report. Getting the attached error.

[Ankur Bawiskar]

@GBS 

did you check with that user you are able to open metric_instance.LIST table and see the data?

[GBS]

@Ankur Bawiskar 

user was able to see the data in the table list view, but unable to view the report 

[Ankur Bawiskar]

@GBS 

strange

is it visible for admins?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[GBS]

@Ankur Bawiskar Yes it is visible for admins and I have also found that to view the sys_db_view table, the admin role is mentioned in the ACL

[Ankur Bawiskar]

@GBS 

which ACL are you referring? please share screenshots.