How can I use just a pg schema or view as data source


#1

I want the users in the group to only have the select privilege in certain schema or even a created view.
I’m wondering how can I do that.
Thanks!


#2

Just create a role (user) in the Postgres, grant this user select privelege only to needed views/schemas, create new DB connection in re:Dash using this user’s credentials, and share this connection with the re:Dash group.


#3

Thanks nilya! As I’m not the admin of the database, so I figured it out with adding another query_runner as a subclass of Redshift class, which assert the schema in the query is the one I want to grant the privilege to.