AWS Builder Center is the official home for builders on AWS. Share and read what others are working on, follow people who inspire you, explore training and workshops, and find tools to support what you're building.
Redshift User Permission to View Granted Schema Only in Database Explorer
IHAC created a Redshift user, and he wished a way to achieve a reduced view in the database explorer tool when this user connects to Redshift using Workbench/J. That is, if the user is granted to use schema abc only, then in the database explorer tab of Workbench/J, he is only supposed to view this schema, rather than all the schemas now in the Redshift database. Is there a practical way to achieve this?
- 语言
- English
已提问 4 年前581 查看次数
- 最新
- 投票最多
- 评论最多
That could be something that is a feature of SQL Workbench/J. Redshift being a server, is returning results to whatever query the client fires, in this case the client being SQL Workbench/J. Note that public schema is always visible to all users.
