awslabs / awslabs/amazon-redshift-utils

Drop user with altered default privileges.

Open
#492 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.