'getting error while droping user from redshift
In AWS redshift I am using superuser to drop the user and also removed all the dependencies but still getting the following error.
No row in the coming after running scripts in the below URL. https://github.com/gdex-lab/redshift-tools/blob/master/scripts/drop_redshift_user.py
SQL Error [500310] [2BP01]: Amazon Invalid operation: user "xxxxx" cannot be dropped because some objects depend on it Details: 1 object in database dev;
Could Pls help me in this regard?
Solution 1:[1]
Have you used this code provided by awslabs to identify all objects owned by a user? https://github.com/awslabs/amazon-redshift-utils/blob/master/src/AdminViews/v_find_dropuser_objs.sql
It is a common challenge to find everything that a user owns.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Bill Weiner |