Manage schema permissions

[fonmarcelo]

Hi guys!
How do I get only a group of users to have access to a connection-specific schema?

Example:
Connection "Test" has schemas A, B and C, and I would like user “John” to have access only to schema A.

[lukas_fontanill]

Hey @fonmarcelo, that’s a great question. Out of curiosity, what db dialect is this connection of? Typically user specific restrictions to schema’s or tables on the database would best be done via an OAuth connection setup (I believe only possible for BigQuery or Snowflake connections currently). For clarity are we trying to restrict users’ access to explores based off of these schemas, restrict user’s ability to query these schemas in sql runner, etc.?