GitHub user dosubot[bot] added a comment to the discussion: Want to access two schema/database information using on database connection in superset if database/schema coming from starrock query engine
<!-- Answer --> Superset will only show the databases and schemas that the StarRocks user (in your case, user1) has permission to access. This is handled by the StarRocks permission system itself—Superset uses the credentials in the connection string and relies on StarRocks to determine which databases are visible. If user1 only has access to db1 and db2, only those will appear in Superset when connecting with user1’s credentials. There’s no extra configuration needed in Superset for this; just make sure the StarRocks user permissions are set as you want them, and use that user in your Superset database connection string. Superset does not apply any additional filtering or privilege escalation beyond what the StarRocks user account allows, and this mapping is direct and 1:1 between StarRocks privileges and Superset visibility [(reference)](https://github.com/apache/superset/blob/11a9f2fe4cfe5df9f3315fd571e6f653eba1f587/superset/db_engine_specs/starrocks.py). <!-- 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/e32d33cc-658a-4113-b41e-eb6195240dad?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/e32d33cc-658a-4113-b41e-eb6195240dad?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/e32d33cc-658a-4113-b41e-eb6195240dad?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/e32d33cc-658a-4113-b41e-eb6195240dad?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/e32d33cc-658a-4113-b41e-eb6195240dad?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/e32d33cc-658a-4113-b41e-eb6195240dad?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/e32d33cc-658a-4113-b41e-eb6195240dad?feedback_type=other)</sup> [](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/discussions/33911) GitHub link: https://github.com/apache/superset/discussions/33911#discussioncomment-13576284 ---- 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]
