GitHub user dosubot[bot] added a comment to the discussion: Seeking Some Help On DataSource Security / RLS
<!-- Answer --> In Superset, you can configure access for users to view datasets they have created without granting full database access by using roles. Specifically, you can manage data source access for users with the **Gamma** role. You can create a new role and assign specific datasets to this role, allowing users with the **Gamma** role to view only those datasets. This setup allows users to see the objects associated with the tables you have extended to them without needing full database access <sup>[[1]](https://github.com/apache/superset/blob/master/docs/docs/security/security.mdx)</sup>. Additionally, Superset automatically assigns ownership of virtual datasets to the creator, which can help in granting access. This is achieved through a migration script that associates the creator's user ID with the dataset, ensuring that the creator is automatically assigned as the owner <sup>[[2]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2022-07-05_15-48_409c7b420ab0_add_created_by_fk_as_owner.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2016-06-27_08-43_27ae655e4247_make_creator_owners.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/990f8f0b-2be2-45bf-bfed-c47954d86ddb?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/990f8f0b-2be2-45bf-bfed-c47954d86ddb?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/990f8f0b-2be2-45bf-bfed-c47954d86ddb?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/990f8f0b-2be2-45bf-bfed-c47954d86ddb?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/990f8f0b-2be2-45bf-bfed-c47954d86ddb?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/990f8f0b-2be2-45bf-bfed-c47954d86ddb?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/990f8f0b-2be2-45bf-bfed-c47954d86ddb?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33308#discussioncomment-13016992 ---- 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]
