We are planning to have a Redshift database with multiple schemas. Each schema will be limited to different users. When creating a datasource and dataset in Quicksight, all users see all schemas. Is there a way to limit the schemas that a user can see within the QS console to be only the schemas t…

Hello @thishali ! I think your best bet is to do this outside of Quick Sight. I recommend checking this out: GRANT - Amazon Redshift Defines access privileges for a user or user group. Use this command to give specific privileges on a table, database, or schema. …

Restricted access to Redshift schemas per user

Q&A

WLS-D July 29, 2024, 3:02pm 2

Hello @thishali !

I think your best bet is to do this outside of Quick Sight. I recommend checking this out:

1 Like

Topic		Replies	Views
How can I hide some schemas in database to create a dataset Q&A data-source , feature-request	4	518	February 1, 2023
Quick Sight display all schema in RedShift Q&A redshift	1	479	March 6, 2023
I want to restrict some of the schema in my Redshift DB for my Quicksight User Q&A data-source , row-level-security , accessibility , direct-query	2	627	March 15, 2023
Sort view of schemas Q&A data-source , feature-request	3	178	March 22, 2023
Reuse Redshift RLS while accessing Redshift via Quicksight Q&A row-level-security , redshift	4	860	October 4, 2022

Restricted access to Redshift schemas per user

Related topics