3 回答
- 最新
- 投票最多
- 评论最多
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.
- Download the v_generate_user_grant_revoke_ddl.sql from the AWS Labs GitHub repository.
- 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>';
- Find all granted permissions by group that you want to drop. Then, re-apply those permissions as another group.
- Drop the group.
0
Yes, I have done this as well but select statement not returning anything.
已回答 4 个月前
相关内容
- 已提问 1 年前
- AWS 官方已更新 10 个月前
- AWS 官方已更新 5 个月前