awslabs / amazon-redshift-utils

Amazon Redshift Utils contains utilities, scripts and view which are useful in a Redshift environment
Apache License 2.0
2.76k stars 1.25k forks source link

v_generate_user_grant_revoke_ddl.sql generates invalid SQL when datashares are used #711

Open dondrake opened 8 months ago

dondrake commented 8 months ago

Latest version of the script generates SQL "REVOKE ALL ON DATABASE ..." on datashares which is invalid syntax.

Can this get updated to support datashares?