GitHub user inkerinmaa created a discussion: Superset DB roles access filters
I configured role and granted access to 2 datasets. They appear in DB. Query I
used:
`SELECT
abr.id AS role_id,
abr.name AS role_name,
rfr.rls_filter_id AS filter_id,
rft.table_id AS table_id,
t.table_name
FROM public.ab_role abr
JOIN public.rls_filter_roles rfr ON abr.id = rfr.role_id
JOIN public.rls_filter_tables rft ON rfr.rls_filter_id = rft.rls_filter_id
JOIN public.tables t ON rft.table_id = t.id`
Next, I removed access for 1 dataset, checked - no access anymore to that
dataset fro this role. But query still shows I have access. How to confirm
there are no access, how to see this in db?
GitHub link: https://github.com/apache/superset/discussions/35635
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
