Google Drive Permissions

Options on google assignments

Delete and reassign approach

Update approach

Permission Assignment Logic

uhtnp is never removed from the google drive.

EXLUDED role never has google permissions so do nothing related to this role.

APPLICANT role permissions are controlled by the system, meaning that the applicant cannot be removed from this role once it’s set.

The following logic applies for users with multiple roles

If a user is removed from an application_role (committee member, APPEALS_PANEL, COLLEAGUE) for an application

  • if the user holds a system_role (CHANCELLOR, COORDINATOR, EXAMINER, UHPA_REP) for the office of the application

    • do not remove their google drive permissions

  • otherwise

    • remove them from the google drive for that application

If a user is removed from a system role (CHANCELLOR, COORDINATOR)

  • search for all applications for the office

  • search the application_role table where the user holds an application role (committee member, APPEALS_PANEL, COLLEAGUE) and return the person_id, application_id, role_id, office_id (from the application), state_id (from the application)

    • loop through the applications from first query

      • if application.office_id = system_role.office_id

        • if the application_role is COLLEAGUE and in State 101, don’t add application to List

        • if the application_role is APPEALS_PANEL and in State 118, don’t add application to List

        • if the application role is committee member

          • if the status of the application is at that committee member’s committee

            • don’t add application to List

      • add application to List

  • List is the applications to pass in to PermissionServiceImpl.revokeAccess(List<Application> applications, Person p)

 

 

 

System role

Application role

Has Drive Access At Some Point?

 

System role

Application role

Has Drive Access At Some Point?

APPLICANT

 

x

x

CHANCELLOR

x

 

x

COORDINATOR

x

 

x

DPC_REVIEWER

 

x

x

DPC_CHAIR

 

x

x

DC_REVIEWER

 

x

x

DC_CHAIR

 

x

x

DEAN_REVIEWER

 

x

x

DEAN_CHAIR

 

x

x

TPRC_REVIEWER

 

x

x

TPRC_CHAIR

 

x

x

EXCLUDED

 

x

 

ADMINISTRATOR

x

 

 

SUPER_USER

x

 

 

UHPA_REP

x

 

x

APPEALS_PANEL

 

x

x

COLLEAGUE

 

x

x

EXAMINER

x

 

x

State 101 = IN PROGRESS

Google Permission

State 101 = IN PROGRESS

Google Permission

Applicant

Content Manager

Colleague

Viewer

uhtnp

Manager

State 101 = SUBMITTED

Google Permission

State 101 = SUBMITTED

Google Permission

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager

State 103 & 121, 105, 107 & 131, 109 & 113 = 

DPCREVIEW & DPC REVIEWING 2ND TIME or DCREVIEW or DEANREVIEW or TPRCREVIEW & TPRC REVIEWING 2ND TIME

Google Permission

State 103 & 121, 105, 107 & 131, 109 & 113 = 

DPCREVIEW & DPC REVIEWING 2ND TIME or DCREVIEW or DEANREVIEW or TPRCREVIEW & TPRC REVIEWING 2ND TIME

Google Permission

Committee Member

Viewer

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager

State 114 & 132 = CHANCELLOR ASSESSMENT

Google Permission

State 114 & 132 = CHANCELLOR ASSESSMENT

Google Permission

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager

State 122 = PRESIDENT REVIEWING

Google Permission

State 122 = PRESIDENT REVIEWING

Google Permission

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager

State 111, 119, 130 = AWAITING APPLICANT

Google Permission

State 111, 119, 130 = AWAITING APPLICANT

Google Permission

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager

State 120 = APPLICANT REVIEWING

Google Permission

State 120 = APPLICANT REVIEWING

Google Permission

Applicant

Viewer

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager

State 120 = APPLICANT REVIEWING

Google Permission

State 120 = APPLICANT REVIEWING

Google Permission

Applicant

Content Manager

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager

State 115, 123, 133 = FINAL, WITHDRAWN, FINAL

Google Permission

State 115, 123, 133 = FINAL, WITHDRAWN, FINAL

Google Permission

Applicant

Viewer

Examiner

Viewer

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager

State 118 = UNDER APPEAL

Google Permission

State 118 = UNDER APPEAL

Google Permission

Applicant

Viewer

Appeals Panel

Viewer

UHPA Rep

Viewer

Coordinator

Viewer

Chancellor

Viewer

uhtnp

Manager