awslabs / awslabs/amazon-redshift-utils
Drop user with altered default privileges.
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
I am trying to user `v_generate_user_grant_revoke_ddl` to change user ownership and drop user. But I am having issues with `default acl`.
Suggested step does not handle that case
`select regexp_replace(ddl,grantor,'') from v_generate_user_grant_revoke_ddl where grantor='' and ddltype='grant' and objtype <>'default acl' order by objseq,grantseq;`
And get this error
`owner of default privileges on new relations belonging to user`
Contributor guide
Research direction
Start with the v_generate_user_grant_revoke_ddl view and reproduce the shown query for a user with altered default privileges. Done means the ownership and drop-user workflow handles the default acl case without the reported owner-of-default-privileges error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100