Question

Manage schema permissions

  • 24 December 2020
  • 1 reply
  • 73 views

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.


This topic has been closed for comments

1 reply

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.?