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

Relevant questions

RDSADMIN_UTIL: what syntax to grant a system privilege?

Oracle sys.utl_recomp grant permission to user

How to grant permission to create a log file in sagemaker?

Redshift - How to grant user permission to SELECT from a view without granting access to the underlying external table

I cannot seem to create schema-level permissions in Babelfish