awslabs / awslabs/amazon-redshift-utils
v_find_dropuser_objs.sql not identifying datashares owned the user.
Open
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
When using the Redshift admin view 'v_find_dropuser_objs.sql', it does not identify the datashares owned by the user.
Contributor guide
Research direction
Open v_find_dropuser_objs.sql and inspect how it finds objects owned by a user, starting with the existing ownership query. Verify the view against Redshift datashares owned by a user; done means those datashares appear in its results.
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
- 45/100