Redshift Datashare: Grant CREATE DATASHARE permissions to users

0

Hi,

Is it possible to grant users permission to create a datashare?

Running command GRANT CREATE DATASHARE TO user;

errors out with:

Grant/Revoke system privilege on User is not supported.

I see that its possible to grant it on a role level, but I'm hoping it's possible to provision it on a user level.

Thanks!

質問済み 2年前2671ビュー
1回答
1
承認された回答

Hello,

Thank you for reaching out to AWS. Kindly find the details you are looking for :-

ALTER and SHARE are the only privileges that you can grant to users and user groups.

The following is the syntax for using GRANT for datashare privileges on Amazon Redshift. ALTER and SHARE are the only privileges that you can grant to users and user groups in this case.

GRANT { ALTER | SHARE } ON DATASHARE datashare_name
TO { username [ WITH GRANT OPTION ] | ROLE role_name | GROUP group_name | PUBLIC } [, ...]

https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html

I Hope this is helpful.

Thank you !

AWS
回答済み 2年前

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

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

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

関連するコンテンツ