there is a sql query that joins both example1.dbo.table1 and example2.dbo.table2
User1 has no select permission on example1 DB.
User1 has select permission on example2 DB.
User2 can run that query
how can User1 run that query ? I dont want to give select permission to User1.
Is there any possibility of that ?
I created this query as procedure and added "execute as user2" inside of it but still couldn't run for User1.