Search code examples
amazon-redshiftprivilegesuser-permissions

Dropping a User, Handling Blank Default Privileges in Redshift, pg_default_acl


I am looking to reset permissions in a Development environment and I noticed two users I could not drop. I checked all of the permissions etc and the only reference to these users I found was in pg_default_acl.

select * from pg_default_acl;

Returns:

defacluser   |   defaclnamespace   |   defaclobjtype   |   defaclacl
----------------------------------------------------------------------
101          |   0                 |               r   |   {}
122          |   0                 |               r   |   {}

Are these empty permissions preventing me from dropping these users?


Solution

  • I ended up finding a resolution when I came across these admin scripts on github:

    awslabs/amazon-redshift-utils

    The issue ended up being default privileges that were granted to other users.