Redshift group cannot be dropped because permission dependency is found

0

not able to drop the group in redshift database facing the error group "XXXX" cannot be dropped because permission dependency is found

asked 3 months ago260 views
3 Answers
0

You can drop a group, after you revoke any permissions that the group has for objects to do this please follow the below steps.

  1. Download the v_generate_user_grant_revoke_ddl.sql from the AWS Labs GitHub repository.
  2. Find the permissions granted to the group using the below SQL.
 select ddl from admin.v_generate_user_grant_revoke_ddl where ddltype='revoke' and grantee= 'group <group-name>'; 
  1. Find all granted permissions by group that you want to drop. Then, re-apply those permissions as another group.
  2. Drop the group.
profile pictureAWS
EXPERT
answered 3 months ago
0

Yes, I have done this as well but select statement not returning anything.

Enter image description here
Enter image description here

answered 3 months ago
0

Enter image description here

answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions