gaepdit / complaint-tracking

Complaint Tracking System
The Unlicense
1 stars 3 forks source link

Design user roles #23

Closed dougwaldron closed 7 years ago

dougwaldron commented 7 years ago

Roles:

Ref: Role based Authorization \ Microsoft Docs

Imported from JIRA: [CTS-4] Design user roles (original by Douglas Waldron)

dougwaldron commented 7 years ago

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

dougwaldron commented 7 years ago

Customizing ASP.NET Authentication with Identity - Microsoft Virtual Academy

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

dougwaldron commented 7 years ago

Current roles:

148 CTS_MASTER Administrative rights to the application
149 CTS_MANAGER Manager rights to the application
150 CTS_OFFICER Officer rights to the application
228 CTS_DIVISION_MANAGER Division Manager rights to the application

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

dougwaldron commented 7 years ago

Currently, CTS_MASTER role is actually only applied to the "master-" principals (accounts). There are 17 master accounts:

SELECT p.OID
, p.USERNAME
, p.EMAIL
, p.FULL_NAME
FROM COMMON.PRINCIPAL p
INNER JOIN COMMON.PRINCIPALTOROLE pr
ON p.OID = pr.USER_ID
INNER JOIN COMMON.ROLE r
ON pr.GROUP_ID = r.OID
WHERE p.ACCOUNT_DISABLED='N'
and r.OID = 148
7812 master-sbeap Teresa.Shiflett@dnr.state.ga.us Sbeap
7441 master-pcbert jerry.campbell@dnr.state.ga.us Emergency Response Network
7442 master-pcbtox Randy.Manning@dnr.state.ga.us Pcb-Tox
7443 master-pcbrad irene.bennett@dnr.state.ga.us Pcb-Radioactive Materials Pgm
7444 master-pcbne bonnie.pope@dnr.ga.gov Pcb-Northeast Distict
7446 master-pcbmd todd.bethune@dnr.ga.gov Pcb-Md
7447 master-apb Sean.Taylor@dnr.ga.gov Air Protection Branch
7448 master-lpb Shaheer.Muhanna@dnr.state.ga.us Lpb
7449 master-wrb ted.jackson@dnr.state.ga.us Drinking Water Program
7515 master-gsb bill.smith@dnr.state.ga.us Gsb
7676 master-pcbecd janice.rachels@dnr.state.ga.us Pcb-East Central District
7692 master-do jim.ussery@dnr.state.ga.us Master
7701 master-pcbmod talina.zuegel@dnr.state.ga.us Pcb-Mountain District
7747 master-pcbcd patricia.banks@dnr.ga.gov Pcb-Cd
7960 master-pcbrsp al.frazier@dnr.state.ga.us Pcb-Risk Management Pgm
11246 master-wpb marzieh.shahbazaz@dnr.state.ga.us Marzieh Shahbazaz
11505 master-pcbsw lisa.myler@dnr.state.ga.us Lisa Myler

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

dougwaldron commented 7 years ago

There is only one CTS_DIVISION_MANAGER user:

11348 divmanager bert.langley@dnr.state.ga.us Bert Langley

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

dougwaldron commented 7 years ago

There are 123 CTS_OFFICER and 632 CTS_DIVISION_MANAGER users. These are probably reviewer- and user-style roles.

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

dougwaldron commented 7 years ago

Based on meeting with Bert Langley and Jim Cooley, master role will be property of Branch, rather than a separate role/account like before.

So three roles:

by 557058:64b0cf35-1c06-4e6d-aac4-6d8e6a3aca41

dougwaldron commented 7 years ago

Doug Waldron mentioned this issue in a commit of ga-epd-it/complaint-tracking:
'Display account roles'

by 557058:69608212-b764-4434-86ee-a573217c2d6e