How do you run a query as the owner but use a parameter as a viewer

ncouture — Wed, 02 Nov 2022 06:03:47 GMT

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

Re: How do you run a query as the owner but use a parameter as a viewer

ncouture — Thu, 03 Nov 2022 21:44:32 GMT

It is not possible to do what I want. Somewhat seems like a security flaw but what ever

topic How do you run a query as the owner but use a parameter as a viewer in Data Engineering

How do you run a query as the owner but use a parameter as a viewer

Re: How do you run a query as the owner but use a parameter as a viewer