search

gaepdit / iaip

Integrated Air Information Platform
https://iaip.gaepd.org/
The Unlicense
0 stars 0 forks source link

Permission interference in SSPP app log tool #1320

Closed dougwaldron closed 6 months ago

dougwaldron commented 6 months ago

Reported by Wendy: SSPP Program Manager role disables some permissions granted by the SSPP Unit Manager role.

dougwaldron commented 6 months ago

https://github.com/gaepdit/iaip/blob/567c2531298b4def24e730a9d9bb5b667b923980/IAIP/SSPP/SSPPApplicationTrackingLog.vb#L1810-L1814

select *
from LOOKUPIAIPACCOUNTS
where Active = 1
  and (STRFORMACCESS like '%(3-_,1,_,0)%'
    or STRFORMACCESS like '%(48-_,1,0,0)%')
NUMACCOUNTCODE STRACCOUNTDESC
112 RMP Specialist
113 SSCP Engineer
122 SSPP Engineer
dougwaldron commented 6 months ago

Should also add these:

NUMACCOUNTCODE STRACCOUNTDESC
28 SSPP Program Manager
121 SSPP Unit Manager