Internal Errigal Collaboration Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

=====ExteNetInocUserHasChangedUserprofilePermissions=====

**Level:**   __Major__    


**Purpose:** Notify operations when an ExteNet INOC user changes their user account profile/visibility.

**Scenario:** A INOC user has changed their account to allow them access to additional areas of the IDMS suite. INOC users should have the following permissions:
  * Profile: NOC (where visibility_profile_uuid = '824fec12-5487-430b-9a2f-e5eb38caa434')
  * Visibility: ExteNet (where business_profile_uuid = '785580bb-9c2a-422e-b0f9-f531ef76a9e6')

**Resolution:** Restore profile to NOC &  visibility to Extenet. If any INOC user has upgraded to an Admin profile this needs to be brought to the attention of Anthony or Loughlin.

**Manual Action Steps:** Query to return profile & visibility of User/s causing alert. 
<code>select 
    ap.username,
	concat(first_name, ' ', last_name) as name,
    ap.email_address,
    bp.name as profile,
	vp.name as visibility
from
    userprofile.app_user ap
	join userprofile.visibility_profile vp
	on vp.uuid = ap.visibility_profile_uuid
	join userprofile.business_profile bp
	on bp.uuid = ap.business_profile_uuid
where
    ap.email_address like '%inoc%'
        and (ap.visibility_profile_uuid != '824fec12-5487-430b-9a2f-e5eb38caa434'
        or ap.business_profile_uuid != '785580bb-9c2a-422e-b0f9-f531ef76a9e6');</code>
  


**Auto Clear:** Will clear when all INOC users have NOC profile & ExteNet visibility.

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools