Redshift User Permission to View Granted Schema Only in Database Explorer

0

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?

AWS
Lei
質問済み 2年前269ビュー
1回答
0

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.

profile pictureAWS
回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ