betodealmeida commented on PR #24739: URL: https://github.com/apache/superset/pull/24739#issuecomment-1644034609
> @mdeshmu: But just FYI, I was able to use `set search_path` in SQL Lab to a schema other than the one chosen in drop down and could successfully query data from the PostgreSQL table using its non-fully qualified table name. Right, I should've been more clear about this. This is probably because by default you have access to the **whole database**; in that case, setting the path is fine. The check only happens when the user doesn't have full database access, when we're checking if the user has access to the schema or the table. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
