GitHub user dosubot[bot] added a comment to the discussion: After granting admin privileges to a user, when I log in to view the user list, it prompts that access is denied. What is the reason for this
<!-- Answer --> To view the user list in Apache Superset, the user needs the "read" permission for the "list" method <sup>[[1]](https://github.com/apache/superset/blob/master/superset/constants.py)</sup>. If the user with admin privileges is still experiencing access denied errors, it might be due to known issues in certain versions of Superset. For instance, in version 4.1.1, enabling SSO with Microsoft O365 can cause permission denied errors for User Info and List Users pages, even with admin roles assigned. This can be resolved by using MySQL instead of SQLite for the metadata database, ensuring role tables are updated, and verifying correct role definitions in the new database <sup>[[2]](https://github.com/apache/superset/discussions/32299)</sup>. Additionally, check the `EXCLUDE_USERS_FROM_LISTS` configuration setting, as it can exclude certain users from appearing in user lists <sup>[[3]](https://github.com/apache/superset/blob/master/superset/security/manager.py)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/f9deb897-499b-4584-acb6-1d8d1361ec83?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/f9deb897-499b-4584-acb6-1d8d1361ec83?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/f9deb897-499b-4584-acb6-1d8d1361ec83?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/f9deb897-499b-4584-acb6-1d8d1361ec83?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/f9deb897-499b-4584-acb6-1d8d1361ec83?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/f9deb897-499b-4584-acb6-1d8d1361ec83?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/f9deb897-499b-4584-acb6-1d8d1361ec83?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/32816#discussioncomment-12599663 ---- 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]
