Zend certified PHP/Magento developer

magento 2 can anyone tell me how to get user permissions list from database . I need query for this .Please help me

Query to get user permissions list in magento2

Admin roles role_type table column

I found related query in above link but permission column is missing . Permission column exists in authorization rule table. So I am stuck with joining the table . So please anyone tell me the query to retrieve all user permissions list from database.