Relevant - confirming that schema perms are managed as part of `dataset_after_update` and oddly at first sight, not on `dataset_after_insert`, unless I'm missing anything, like after_update called after insert somewhere?
https://github.com/apache/superset/blob/7397ab36f2872a709a5219e5318bd79aacb89930/superset/security/manager.py#L1345-L1377 On Fri, 4 Aug 2023 at 12:29, Maxime Beauchemin <maximebeauche...@gmail.com> wrote: > I haven't looked at the code, but as a workaround, creating one dataset on > that schema may create the schema-level permission. Also I think > schema-level permissions don't apply to SQL Lab (not sure). > > Thinking about solutions, Superset could use some sort of [optional] > database agent that would maintain things like this (perms) but potentially > table name caches and such to allow for cross-schema table names cache. > > Max > > On Wed, 2 Aug 2023 at 09:58, Modi, Tejas Piyush <tm...@deloitte.com.invalid> > wrote: > >> Hello Team, >> >> >> >> I hope to find you in good health. >> >> I have been working on an implementation where we are providing >> permissions to different schemas through user roles. >> >> We encountered a scenario as described below: >> >> 1. A new schema was created in Redshift database. We have an existing >> database connection for this in Superset. >> >> New Schemas in Database : >> >> Existing DB Connection in Superset >> >> >> >> 1. We tried granting schema_access permission for this new schema by >> trying to add it in permission list for an existing group. *The >> schema name does not come up in this list.* >> >> List does not show testing_superset2 schema: >> >> 1. We are able to query same schema through sqllab using an admin >> role. But currently unable to set permission on the schema’s access as it >> does not show up. >> >> Schema and table accessible through SQLLab: >> >> >> >> Any Help in understanding this scenario and resolving it will help. >> >> >> >> *Regards,* >> >> *Tejas Modi* >> >> Senior Consultant | ConvergeHEALTH – Expert Services >> >> Core Industry Solutions | Core Business Operations >> >> Deloitte Consulting USI Pvt. Ltd. >> >> tm...@deloitte.com | www.deloitte.com >> >> Please consider the environment before printing >> >> >> >> This message (including any attachments) contains confidential >> information intended for a specific individual and purpose, and is >> protected by law. If you are not the intended recipient, you should delete >> this message and any disclosure, copying, or distribution of this message, >> or the taking of any action based on it, by you is strictly prohibited. >> >> Deloitte refers to a Deloitte member firm, one of its related entities, >> or Deloitte Touche Tohmatsu Limited ("DTTL"). Each Deloitte member firm is >> a separate legal entity and a member of DTTL. DTTL does not provide >> services to clients. Please see www.deloitte.com/about to learn more. >> >> v.E.1 >> >