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
>
