I'm trying to solve a question, but I don't have any idea about how I can get the solution.
IT Audit is asking for those users who has permissions over a database.
I began to write a python script which connects with impala and list all roles, and one by one I'm asking if that role has permission on the database, but I don't know how can I list all users that have each role assigned.
Anyone know how can I get that information?
... View more