By using AWS re:Post, you agree to the Terms of Use

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!

asked 2 months ago27 views
1 Answers
1
Accepted Answer

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 !

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions