You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "IMYR666 (via GitHub)" <gi...@apache.org> on 2025/09/08 07:45:30 UTC
[I] Cannot prohibit downloading and copying data in results. [superset]
IMYR666 opened a new issue, #35047:
URL: https://github.com/apache/superset/issues/35047
### Bug description
The bug is:
As long as there is permission to "can get results on SQLLAB", data in results can be downloaded and copied, even though the "can export csv on SQLLab" permission has been revoked.
<img width="418" height="574" alt="Image" src="https://github.com/user-attachments/assets/fba7e150-0c76-44f3-971d-ffafee53886e" />
### Screenshots/recordings
_No response_
### Superset version
master / latest-dev
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
--
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.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: [I] Cannot prohibit downloading and copying data in results. [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #35047:
URL: https://github.com/apache/superset/issues/35047#issuecomment-4748619295
The interaction between 'can get results' and 'can export csv' here is behaving as currently designed. Restricting download separately would be an enhancement. This is probably better tracked as a Discussion, or even a PR. Closing for now, but please reopen with a concrete proposal if you'd like to drive it.
--
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: [I] Cannot prohibit downloading and copying data in results. [superset]
Posted by "IMYR666 (via GitHub)" <gi...@apache.org>.
IMYR666 commented on issue #35047:
URL: https://github.com/apache/superset/issues/35047#issuecomment-3265084200
How does the frontend disable the` Copy the current data` and `Download to CSV` functions in the results table? [@dosu](https://go.dosu.dev/dosubot).
--
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: [I] Cannot prohibit downloading and copying data in results. [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #35047: Cannot prohibit downloading and copying data in results.
URL: https://github.com/apache/superset/issues/35047
--
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: [I] Cannot prohibit downloading and copying data in results. [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #35047:
URL: https://github.com/apache/superset/issues/35047#issuecomment-3267193731
Per @sadpandajoe's suggestion, we need to figure out when this was added and suss out the intent. We should also probably add documentation around this and other permissions to explicitly state their purpose, and how they combine/interact with other settings.
--
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: [I] Cannot prohibit downloading and copying data in results. [superset]
Posted by "IMYR666 (via GitHub)" <gi...@apache.org>.
IMYR666 commented on issue #35047:
URL: https://github.com/apache/superset/issues/35047#issuecomment-3265088107
Additional Information: The version I am currently using is 5.0.0.
--
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: [I] Cannot prohibit downloading and copying data in results. [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #35047:
URL: https://github.com/apache/superset/issues/35047#issuecomment-3265026338
<!-- Greeting -->
Hi @IMYR666! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team.
<!-- Answer -->
This is a confirmed limitation in Superset: if a user has the "can get results on SQLLAB" permission, they can view, copy, and download data from SQLLab results, even if the "can export csv on SQLLab" permission is revoked. The frontend checks "can_export_csv" for both the "Download to CSV" and "Copy to Clipboard" buttons, so revoking it hides those options in the UI, but there is no separate permission for copying data—it's gated by the same export permission. The backend only enforces "can get results" for fetching data and does not restrict copying or downloading beyond what the frontend controls. There is currently no granular way to prohibit copying data separately from exporting CSV; users with access to results can always copy visible data as long as they can view it in the browser. [Source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/SqlLab/components/ResultSet/index.tsx)
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
---
<sup>How did I do? [Good](https://app.dosu.dev/response-feedback/a4d1b5ed-5930-4a92-bcc1-2fd74c79cdd7?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/a4d1b5ed-5930-4a92-bcc1-2fd74c79cdd7?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/a4d1b5ed-5930-4a92-bcc1-2fd74c79cdd7?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/a4d1b5ed-5930-4a92-bcc1-2fd74c79cdd7?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/a4d1b5ed-5930-4a92-bcc1-2fd74c79cdd7?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/a4d1b5ed-5930-4a92-bcc1-2fd74c79cdd7?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/a4d1b5ed-5930-4a92-bcc1-2fd74c79cdd7?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu
b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/35047)
--
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: [I] Cannot prohibit downloading and copying data in results. [superset]
Posted by "LisaHusband (via GitHub)" <gi...@apache.org>.
LisaHusband commented on issue #35047:
URL: https://github.com/apache/superset/issues/35047#issuecomment-3367975213
There seem to be two conflicting permission rules, which should perhaps be discussed by the community. My suggestion is to refer to the data permission management principles of large Chinese Internet companies (Ant Group) and follow the principle of least privilege, that is, to follow the latter in the issue description as a benchmark.
--
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