Can you try with giving WITH NOLOCK with the tables used in the query?

In view we can give permission to those view to users, basically its for security purpose.

If users dont want to access some table, but they need some data from...