Hi everyone, I have set up a data source connectio...
# ask-questions
b
Hi everyone, I have set up a data source connection with Redshift. In my GrowthBook schema browser, it shows all schemas in my database. I want it to show only the schemas to which I have granted permission. How can I do that?
r
Hi Narikorn, Thank you for writing in! In GrowthBook, the Schema Browser automatically generates metadata from the connected data source, which includes information about databases, schemas, tables, columns, and data types. However, there isn't a direct way to limit the schemas shown in the Schema Browser to only those to which you've granted permission. As a best practice, GrowthBook recommends creating read-only users with as few permissions as possible - ideally just read permissions on the tables with the data that needs to be aggregated. This means that GrowthBook should only be able to access the schemas and tables that the read-only user has permission to access. If you're seeing schemas in the Schema Browser that the read-only user shouldn't have access to, it might be worth double-checking the permissions for that user in your data warehouse. In parallel to the above, I'm unsure if you are aware already but we have a public facing Feature Suggestion board available here that I recommend to use to submit this idea so that other customers can upvote this suggestion. Hope this helps :)