Need a list of resources by roles/rights in Macola ES

[lrousey]

I need to generate a list of roles and what each of those roles can do (rights) that each of my resources has in Macola ES.

Does anyone know how to do that? I've looked at the following tables, but I'm not having much luck at making any sense of it: pwrole, pwrprm, and pwfunc.

Any help would be greatly appreciated!

Thanks.

Laura

 

[DumpsterGuy]

This is a report I use (the SQL from Crystal)
I was able to grab this by doing a trace on my user and running the Roles report from the Resource entry screen.


SELECT
humres."usr_id", humres."fullname",
pwrole."role_name"
FROM
{ oj ("pwruc" pwruc INNER JOIN "pwrole" pwrole ON
pwruc."role_id" = pwrole."role_id")
INNER JOIN "humres" humres ON
pwruc."res_id" = humres."res_id"}
ORDER BY
humres."usr_id" ASC