Could you guide me how to check the list of databases for which the given user has all permission granted.
for e.g. I grant all permission on database “testdb” to role “test_admin”. Further I would like to pass the role name “test_admin” in sql query to list out the databases for which
this role has all permissions.
GRANT ALL on DATABASE testdb TO "test_admin";
Could you help me