Report is not visible to other people without admin role even if i am sharing the report .

[SamiranD]

@Ankur Bawiskar 

Hi 
i have created a database view with the following tables :
sysauto
sys_import_set_execution 
sys_import_set_run
sys_import_set_row_error
sys_trigger
import_log

and have created a report with the database view. Now users without admin or import_admin role is not able to see the data in report. Now my question is can i create a custom role and add each of these role to the report_view acl of each of the mentioned tables. By doing this can the user having the role can see the report data ?
Please help.

[Ankur Bawiskar]

@SamiranD 

you have lot of OOTB system tables such as Import set run, execution etc

why you want your users to see this information and those table hold technical information

you can try that approach and see how it behaves as I never used those system tables in database view and reporting

what error the user get when they access the report?

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

[SamiranD]

attaching the error.
on giving the import_admin role to user, user can view the whole report

[SamiranD]

Number of groups removed from this list by Security constraints: 10

this is the new error i am getting after i am giving read and report_view acl access to the user

[Ankur Bawiskar]

@SamiranD 

there must be some query business rule on any of those table

Did you check that?

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