Finding similar roles assigned

shekhar8249shekhar8249 Community Edition User

Hi Team,

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?



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file