Finding similar roles assigned
I'm trying to find the similar roles assigned to the users and revoke the inappropriate roles
Ex - Below are the schemas and roles assigned to a user
ab_r - read access
abc_r - read access
abc_rw - read/write access
bcd_r - read access
bcd_rw - read/write access
abcd - read access
I want to remove the abc_r and bcd_r read only access which is already there as part of read/write access to the user.
I need to get the output as roles which need to be revoked for all the users in the DB. Any suggestions?