uPortal IRC Logs-2013-06-26

Owned by Apereo Infrastructure
Last updated: Jun 26, 2013
2 min read

[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 (smile)

[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