Report view problem

[nameisnani]

Hi Team , 

I have created a database view in production . 

Requester , reports like this : - 

Hi, it looks like I do not have the rights to view the created database view, and so I cannot confirm if it is created correcly. Can you assist with understanding what roles are required?

I have checked user profile these are roles user is having 

can any one please help me here , which role should i give to the user 

[Mark Manders]

For starters: you should always create something on DEV to validate if it is correct, instead of on PROD, where you run the risk of breaking things. 

Next to that: you are sharing the roles, but not the database view. For a database view to show correctly, you will also need the read rights to the tables you are referencing. If you are missing that, the data won't show. Also check on the report_view acl's, because that's a blocker as well.

[nameisnani]

@Mark Manders 

could u please provide steps for me with screenshots .

so that i can replcate this 

[Mark Manders]

I can't share screenshots of how to check on ACL's. You open the ACL table and check on the (read) records for the tables you used for your database view. Also the same with report view ACLs.

[nameisnani]

@Mark Manders 

I have opened table option is not there . what should i do