Redshift Datashare: Grant CREATE DATASHARE permissions to users

Question

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!

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 !

Redshift Datashare: Grant CREATE DATASHARE permissions to users

Conteúdo relevante