You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "dgarciabriseno (via GitHub)" <gi...@apache.org> on 2025/11/06 15:51:37 UTC
[PR] docs: Add minimal set of permissions required for public dashboards [superset]
dgarciabriseno opened a new pull request, #36025:
URL: https://github.com/apache/superset/pull/36025
### SUMMARY
Updates the superset documentation on public dashboards to list the minimal set of requirements needed
to make public dashboards work.
Prior to this change, the suggestion is to initialize your superset instance with `PUBLIC_ROLE_LIKE = "Gamma"` but
Gamma permissions are too permissive, with things like write and delete permissions, for a public role.
This is purely a documentation change. I found this set of permissions by starting with all Gamma permissions and deleting permissions until I found the minimal permissions required to have a functional public dashboard without granting excess permissions.
### ADDITIONAL INFORMATION
<!--- Check any relevant boxes with "x" -->
<!--- HINT: Include "Fixes #nnn" if you are fixing an existing issue -->
- [ ] Has associated issue:
- [ ] Required feature flags:
- [ ] Changes UI
- [ ] Includes DB Migration (follow approval process in [SIP-59](https://github.com/apache/superset/issues/13351))
- [ ] Migration is atomic, supports rollback & is backwards-compatible
- [ ] Confirm DB migration upgrade and downgrade tested
- [ ] Runtime estimates and downtime expectations provided
- [ ] Introduces new feature or API
- [ ] Removes existing feature or API
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "dgarciabriseno (via GitHub)" <gi...@apache.org>.
dgarciabriseno commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3550042199
the task is all yours. I just wanted to add things I had to figure out on my own to the docs. Adding a preinstalled role takes all the guesswork out for sure. It should still be documented which capabilities are granted to the public role by default.
for the bigger set of permissions, why does it need:
- can_write on DashboardFilterStateRestApi
- can_explore_json on Superset
- can_sql_json on Superset
I'm wondering why the public role should have any "write" permission, and I'm curious which features are enabled by allowing explore and sql (like are those just needed to be able to interact with the charts?) The others I think make sense and don't look harmful.
Main thing I kind of hinted at about all these permissions is that it's not that clear how the permissions map to end user capabilities. They kind of make sense when you look at the superset API, but not so much when you're working in the app (like trying to figure out what you need for a public user).
Sorry if formatting is bad, I'm replying to the github email.
On November 18, 2025 6:26:19 PM UTC, Sam Firke ***@***.***> wrote:
>sfirke left a comment (apache/superset#36025)
>
>@dgarciabriseno - I just discussed this in the monthly Documentation meeting and the consensus was to go farther and add a new role to Superset, so that admins can just assign it rather than having to create one based on the docs. The way we have Gamma and Alpha already extant in Superset, we'd have Public that way too. Probably with the set of permissions I posted above, unless there are ones you think should be removed.
>
>My question for you: would you like to take on that work? I don't mean to deprive you of the opportunity to contribute to Superset. Or, if this feels like more than you wanted to sign up for, I'm willing to do this myself. Just let me know!
>
>--
>Reply to this email directly or view it on GitHub:
>https://github.com/apache/superset/pull/36025#issuecomment-3549017788
>You are receiving this because you were mentioned.
>
>Message ID: ***@***.***>
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3543413171
Here's my list of permissions for the public role:
```
can read Chart, can annotation json Superset, can csv Superset, can dashboard permalink Superset, can dashboard Superset, can explore json Superset, can favstar Superset, can filter Superset, can get OpenApi, can list FilterSets, can queries Superset, can query Api, can query form data Api, can read AdvancedDataType, can read Annotation, can read CssTemplate, can read Dashboard, can read DashboardFilterStateRestApi, can read DashboardPermalinkRestApi, can read ExploreFormDataRestApi, can read ExplorePermalinkRestApi, can share dashboard Superset, can slice json Superset, can slice Superset, can sql json Superset, can time range Api, can validate sql json Superset, can write DashboardFilterStateRestApi, can write DashboardPermalinkRestApi, can write ExploreFormDataRestApi, can write ExplorePermalinkRestApi
```
I don't have any documentation about what each does, but I think a lot of that might be to make filtering and other interactions work.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke closed pull request #36025: docs: Add minimal set of permissions required for public dashboards
URL: https://github.com/apache/superset/pull/36025
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "dgarciabriseno (via GitHub)" <gi...@apache.org>.
dgarciabriseno commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3534283062
Thanks for verifying this. I'll need to double check my permissions when I'm back at work.
I have a 5.0.0 instance running that I demo'd this morning by opening a private browsing window and it worked fine.
On November 14, 2025 7:05:14 PM UTC, Sam Firke ***@***.***> wrote:
>@sfirke requested changes on this pull request.
>
>I like this idea but I don't think this set of permissions is sufficient. I created a new role with these seven permissions, then gave a dashboard that role and tried to view it in a private browsing window where I wasn't signed in. It didn't work - I was redirected to login.
>
>I have a functional Public role that I've used for several years. It has 31 permissions. I wonder if not all 31 are needed and the minimal set is between yours and mine?
>
>I'm happy to re-review if you can expand this to a set such that once that role is added, I can view the dashboard while logged out.
>
>
>
>--
>Reply to this email directly or view it on GitHub:
>https://github.com/apache/superset/pull/36025#pullrequestreview-3466391311
>You are receiving this because you authored the thread.
>
>Message ID: ***@***.***>
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3670867481
FYI this is being continued and expanded over in github.com/apache/superset/pull/36548. Looks promising so far 🙏 Thanks @dgarciabriseno for getting this started!
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "bito-code-review[bot] (via GitHub)" <gi...@apache.org>.
bito-code-review[bot] commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3497971133
AI Code Review is in progress (usually takes 3 to 15 minutes unless it's a very large PR).
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "dgarciabriseno (via GitHub)" <gi...@apache.org>.
dgarciabriseno commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3542966690
No, mine doesn't have any interactions really, just view only.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3502343623
Great idea, thank you! I should be able to review today.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "dgarciabriseno (via GitHub)" <gi...@apache.org>.
dgarciabriseno commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3542517436
Maybe it's my charts?
The permissions I listed work for the dashboard I've made.
I'm using a custom chart plugin, I don't know if that makes a difference.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3549017788
@dgarciabriseno - I just discussed this in the monthly Documentation meeting and the consensus was to go farther and add a new role to Superset, so that admins can just assign it rather than having to create one based on the docs. The way we have Gamma and Alpha already extant in Superset, we'd have Public that way too. Probably with the set of permissions I posted above, unless there are ones you think should be removed.
My question for you: would you like to take on that work? I don't mean to deprive you of the opportunity to contribute to Superset. Or, if this feels like more than you wanted to sign up for, I'm willing to do this myself. Just let me know!
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3534170733
See for example this list of permissions, it is much longer than yours: https://gist.github.com/byk0t/bd6e9c3839967b4ac28a8da30f468b2a
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] docs: Add minimal set of permissions required for public dashboards [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on PR #36025:
URL: https://github.com/apache/superset/pull/36025#issuecomment-3542905597
Maybe my extra permissions are for other aspects of dashboard interactions. E.g., does your set of permissions allow the public user to filter on a time range?
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org