awslabs / awslabs/amazon-redshift-utils
v_generate_user_grant_revoke_ddl.sql generates invalid SQL when datashares are used
Open
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
Latest version of the script generates SQL "REVOKE ALL ON DATABASE ..." on datashares which is invalid syntax.
Can this get updated to support datashares?
Contributor guide
Research direction
Start with v_generate_user_grant_revoke_ddl.sql and inspect how it generates REVOKE ALL ON DATABASE statements for datashares. Compare the generated SQL with the syntax required for datashares, then verify that the script no longer emits invalid statements when datashares are used.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100