QuickSight display all schema in RedShift

Question & Answer
,
1

Hope you are doing well.

I have a situation: When connecting to RedShift from QuickSight I see all schemas are displayed though the RedShift credentials used has read access only to one. How do I restrict this view, it’s confusing for users to determine which schema to use?

Just as an investigation, I created a user with no access to any schema still it shows all. Any suggestion will be appreciated. Thank you.

2

I believe this is because the quicksight user role has access to see the schema.

I don’t know if limiting it will cause any errors but you can try.