The statement below is for Users:
•Select permissions.permissionname, users.username
•From users, permissions, userpermissions
•Where userpermissions.permissionid = permissions.permissionid and users.userid = userpermissions.userid
The statement below is for Groups and Users.
•Select distinct users.username, permissions.permissionname,applications.name, usergroups.groupname
•From applications, users, permissions, userpermissions, usertogroup, grouppermissions,usergroups
•Where applications.applicationid = grouppermissions.applicationid and userpermissions.permissionid = permissions.permissionid and users.userid = userpermissions.userid and usertogroup.usergroupid = usergroups.usergroupid