Habeeb556 commented on issue #30839: URL: https://github.com/apache/superset/issues/30839#issuecomment-2549748741
> @Habeeb556 I use PostgreSQL. Yes, that is correct. the Gamma permission seems to be correct, the user has a Gamma and **Gamma_demo** permission. The only statement in **Gamma_demo** is `schema access on [DB].[conn].[schema_demo]`. In SQLLab, if you execute a query to any other `[schema_???]` it will return rows. Hmm, that’s wired. Have you tried this with the latest `version 4.1.1`? I simulated this using PostgreSQL and didn’t encounter the issue, whether with PostgreSQL, Oracle, or any other engine driver I tested. After upgrading, make sure to run the following commands to update permissions in the gamma role: ``` superset db upgrade superset init ``` In my simulation, I granted permissions only to `sqllab`, `gamma`, and a `custom role` (newrole) with access restricted to specific schema. Everything worked as expected.  -- 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]
