I have a query that is hitting a table I have access too. Granting access to everyone is not an option. I am using this query in a SQL Dashboard. One of the where clause conditions uses a parameter populated by another query. I want this parameter query to run as the viewer when I share the dashboard to limit what options are presented based on who the viewer is. But its not working that way. It is running it as the owner, ie me, as all options are being shown in the parameter despite having that query saved as run as the viewer.
Is this functionally possible? Or will the parameter query always inherit the permissions from the query calling it?
Thanks
