Drupal role, module & permission

Drupal role, module & permission

SELECT r.name,p.module,p.permission FROM role_permission p

left join role r on p.rid=r.rid

order by name,module, permission