...
[16:33:36 CDT(-0500)] <TonyUnicon> so sql is the avenue we're going but I need to know which table it lives in
[16:34:07 CDT(-0500)] <TonyUnicon> the ssp_roles themselves live in up_permission_activity
[16:34:34 CDT(-0500)] <TonyUnicon> the fk to that table
[16:34:41 CDT(-0500)] <TonyUnicon> points to up_permission_owner
[16:34:49 CDT(-0500)] <TonyUnicon> which are uportal roles
[16:35:04 CDT(-0500)] <TonyUnicon> so I'm completely lost as to how uportal resolves that relationship