[12:50:19 CDT(-0500)] * Topic is 'http://uportal.pastebin.com/ - https://wiki.jasig.org/display/UPC/uportal+IRC+Logs' set by EricDalquist!~apollo@76.210.64.142 on 17:44:12 CDT(-0500)
[15:29:28 CDT(-0500)] <dmccallum54> let's say i want to delete a uPortal permission… i.e. not just de-grant it from all principles… actually delete it at least to the extent it is never again presented on-screen as a grantable permission….is that actually possible?
[15:30:02 CDT(-0500)] <EricDalquist> hrm
[15:30:08 CDT(-0500)] <EricDalquist> I'm honestly not sure
[15:31:05 CDT(-0500)] <dmccallum54> aaand… the gang's all here.
[15:31:38 CDT(-0500)] <EricDalquist> it is
[15:31:41 CDT(-0500)] <EricDalquist> a full house 
[15:31:47 CDT(-0500)] <TonyUnicon> the java implies the its up_permission_owner but looking at that table, those are uportal roles, not spp roles
[16:20:53 CDT(-0500)] <jwennmacher> dmccallum54: did you get an answer on the permission question?
[16:21:34 CDT(-0500)] <dmccallum54> no
[16:22:24 CDT(-0500)] <jwennmacher> What's the permission? Are you able to just remove it from the data import for setting up the portal or do you need to remove it in a running system?
[16:22:45 CDT(-0500)] <dmccallum54> it is a SSP permission. it would already be present in a running system
[16:23:11 CDT(-0500)] <dmccallum54> was accidentally added as a duplicate of another. would like for it to just go away as it serves no purpose now other than distraction
[16:23:57 CDT(-0500)] <dmccallum54> it has already been removed from the importable entities, so wont be added to new installs
[16:31:48 CDT(-0500)] <jwennmacher> You could certainly do it with sql. I don't know of a way to do arbitrary sql on a version upgrade.
[16:32:28 CDT(-0500)] <dmccallum54> TonyUnicon wasnt sure from the recent ticket comments… did you eventually figure out all the SQL?
[16:33:02 CDT(-0500)] <TonyUnicon> no, the core issue still is, I don't know how ssp roles relate to ssp groups
[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
[16:37:39 CDT(-0500)] <TonyUnicon> the fk in that table*
[16:41:50 CDT(-0500)] <TonyUnicon> so for example
[16:42:05 CDT(-0500)] <TonyUnicon> when we seed perms, in this clip http://chopapp.com/#1l6o6q3w
[16:42:25 CDT(-0500)] <TonyUnicon> we define a relationship between an ssp role to ssp perm
[16:42:36 CDT(-0500)] <TonyUnicon> so I assumed there was some cross table with this relationships
[16:42:42 CDT(-0500)] <TonyUnicon> these*
[16:49:29 CDT(-0500)] <TonyUnicon> ok i figured it out
[16:50:01 CDT(-0500)] <TonyUnicon> look at import-permission_set_v3-1.crn
[16:50:08 CDT(-0500)] <TonyUnicon> that holds the answer
[16:53:23 CDT(-0500)] <TonyUnicon> it's worth noting
[16:54:00 CDT(-0500)] <TonyUnicon> I was able to delete the reference permissions without issue, which breaks uportal a little