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? |
---|---|---|---|
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 |
---|---|
Applicant | Content Manager |
Colleague | Viewer |
uhtnp | Manager |
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 |
---|---|
Committee Member | Viewer |
Coordinator | Viewer |
Chancellor | Viewer |
uhtnp | Manager |
State 114 & 132 = CHANCELLOR ASSESSMENT | Google Permission |
---|---|
Coordinator | Viewer |
Chancellor | Viewer |
uhtnp | Manager |
State 122 = PRESIDENT REVIEWING | Google Permission |
---|---|
Coordinator | Viewer |
Chancellor | Viewer |
uhtnp | Manager |
State 111, 119, 130 =Â AWAITING APPLICANT | Google Permission |
---|---|
Coordinator | Viewer |
Chancellor | Viewer |
uhtnp | Manager |
State 120 = APPLICANT REVIEWING | Google Permission |
---|---|
Applicant | Viewer |
Coordinator | Viewer |
Chancellor | Viewer |
uhtnp | Manager |
State 120 = APPLICANT REVIEWING | Google Permission |
---|---|
Applicant | Content Manager |
Coordinator | Viewer |
Chancellor | Viewer |
uhtnp | Manager |
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 |
---|---|
Applicant | Viewer |
Appeals Panel | Viewer |
UHPA Rep | Viewer |
Coordinator | Viewer |
Chancellor | Viewer |
uhtnp | Manager |