Cannot use drill-by/drill-to without can explore on Superset permission

icrc-fdeniger commented 7 months ago

Bug description

A end-user should be able to drill-by/drill-to with 2 permissons:

can read on Explore
can samples on Datasource

Currently can explore is mandatory but it gives too many privileges ( see query, open chart,...)

How to reproduce the bug

Create a user have only the permissions:

can read on Explore
can samples on Datasource

this user can't drill down.

Screenshots/recordings

No response

Superset version

3.1.2

Python version

3.10

Node version

16

Browser

Not applicable

Additional context

No response

Checklist

[X] I have searched Superset docs and Slack and didn't find a solution to my problem.
[X] I have searched the GitHub issue tracker and didn't find a similar bug report.
[X] 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.

chakri0215 commented 5 months ago

Hi Guys,

Any update on this?

tsator commented 5 months ago

I have the same problem, the end user cannot see the drill options without the can explore on superset permission

marianysilva commented 3 months ago

I have the same problem here: I can enable drill to detail by adding the can read on Explore and can samples on Datasource permissions. However, it's noted that the can explore permission is currently mandatory but gives too many privileges.

menu (In red what I don't need) Screenshot 2024-07-31 at 10 05 53