Applicable Versions: v2.06.0
ACCESS | ROLES | |||||||||||
NAME | TOOL | CONFIDENTIALITY LEVEL | Permission/Role | SSP_ADMINISTRATOR | SSP_COACH | SSP_DEVELOPER | SSP_FACULTY | SSP_MANAGER | SSP_MAP_TEMPLATE_ADMIN | SSP_STUDENT | SSP_SUPPORT_STAFF | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
PERSON_CHALLENGE_DELETE | ACTION PLAN | ACCOMMODATION_READ | X | X | X | X | ||||||
ACCOMMODATION_WRITE | X | X | X | X | ||||||||
PERSONAPI_CHALLENGEKEY_READ | ACTION PLANX | X | ||||||||||
API_KEY_WRITE | X | X | ||||||||||
BULK_EMAIL_STUDENT | X | X | X | X | PERSON_CHALLENGE_WRITE | ACTION PLAN | ||||||
BULK_PROGRAM_STATUS | X | X | X | X | ||||||||
BULK_SEARCH_EXPORT | X | X | X | X | X | |||||||
PERSONBULK_GOAL_DELETEACTION PLANWATCHLIST_WRITE | X | X | X | X | ||||||||
DATA_ACADEMIC_RESOURCE_CENTER | X | X | X | |||||||||
PERSONDATA_GOALCOUNSELING_READSERVICES | ACTION PLANX | X | ||||||||||
DATA_DISABILITY | X | X | X | |||||||||
PERSONDATA_GOALDISPLACED_WRITEWORKERS | ACTION PLANX | X | ||||||||||
DATA_EARLY_ALERT | X | X | X | |||||||||
PERSONDATA_ENGLISH_TASK_DELETE | ACTION PLAN | X | XSECOND_LANGUAGE | X | X | |||||||
DATA_EVERYONE | X | X | X | X | X | X | ||||||
DATA_FAST_FORWARD | X | X | ||||||||||
PERSONDATA_INDIVIDUALIZED_TASKLEARNING_READPLANACTION | PLANX | X | ||||||||||
DATA_MANAGER | X | X | X | PERSON_TASK_WRITE | ACTION PLAN | |||||||
DATA_STAFF | X | X | X | X | ||||||||
EXTERNAL_VIEW (1-4) | X | X | PERSON_DELETE | |||||||||
CASELOAD MANAGEMENT | MAP_PUBLIC_TEMPLATE_WRITE | X | X | X | ||||||||
MY_GPS_TOOL | X | X | X | |||||||||
PERSON_APPOINTMENT_DELETE | CASELOAD MANAGEMENTX | X | X | X | ||||||||
PERSON_APPOINTMENT_READ | CASELOAD MANAGEMENTX | X | X | X | X | X | X | |||||
PERSON_APPOINTMENT_WRITECASELOAD MANAGEMENT | X | X | X | X | X | X | ||||||
PERSON_BULK_REASSIGN | X | X | X | X | ||||||||
PERSON_CASELOAD_READCASELOAD MANAGEMENT | X | X | XX | X | X | |||||||
PERSON_PROGRAM_STATUSCHALLENGE_DELETE | CASELOAD MANAGEMENTX | X | X | X | ||||||||
PERSON_PROGRAM_STATUSCHALLENGE_READCASELOAD MANAGEMENT | X | X | X | X | X | |||||||
PERSON_CHALLENGE_WRITE | X | X | X | X | X | |||||||
PERSON_PROGRAM_STATUS_WRITECASELOAD MANAGEMENTDELETE | X | X | ||||||||||
PERSON_DOCUMENT_DELETE | X | X | X | X | X | |||||||
PERSON_SEARCHDOCUMENT_READCASELOAD MANAGEMENT | X | X | X | X | ||||||||
PERSON_DOCUMENT_WRITE | X | X | X | X | X | |||||||
PERSON_EARLY_ALERT_DELETEEARLY ALERT | X | X | X | X | ||||||||
PERSON_EARLY_ALERT_READ | EARLY ALERT | X | X | X | X | XX | X | |||||
PERSON_EARLY_ALERT_RESPONSE_DELETEEARLY ALERT | X | X | X | X | ||||||||
PERSON_EARLY_ALERT_RESPONSE_READ | EARLY ALERT | X | X | X | X | X | ||||||
PERSON_EARLY_ALERT_RESPONSE_WRITE | EARLY ALERT | X | X | X | X | X | ||||||
PERSON_EARLY_ALERT_WRITEEARLY ALERT | X | X | X | X | X | XX | ||||||
PERSON_FILTERED_READ | X | |||||||||||
PERSON_JOURNAL_ENTRY_DELETE | JOURNAL | FILTERED_WRITE | X | |||||||||
PERSON_GOAL_DELETE | X | X | X | X | X | |||||||
PERSON_JOURNAL_ENTRYGOAL_READ | JOURNAL | X | X | X | X | X | ||||||
PERSON_JOURNALGOAL_ENTRY_WRITE | JOURNAL | X | X | X | X | X | ||||||
PERSON_TESTINSTRUCTION_READ | MAIN | X | X | X | X | X | ||||||
PERSON_JOURNAL_ENTRY_DELETE | X | X | X | X | X | |||||||
PERSON_JOURNAL_TRANSCRIPTENTRY_READ | MAIN | X | X | X | X | X | ||||||
PERSON_DOCUMENTJOURNAL_ENTRY_DELETEWRITE | STUDENT DOCUMENTSX | X | XX | X | X | X | ||||||
PERSON_DOCUMENTLEGACY_REMARK_READ | STUDENT DOCUMENTSX | X | XX | X | X X | |||||||
PERSON_DOCUMENTLEGACY_REMARK_WRITE | STUDENT DOCUMENTSX | X | XX | X | X X | |||||||
PERSON_ | ACCOMMODATIONMAP_READ | ACCOMMODATIONS | X | X | X | |||||||
PERSON_MAP_WRITE | X | X | X | X | ROLE | |||||||
PERSON_PROGRAM_ | ACCOMMODATIONSTATUS_ | WRITEDELETE | ACCOMMODATIONSX | XX | X | |||||||
STUDENTPERSON_PROGRAM_INTAKESTATUS_READINTAKE | X | X | X | X | XX | X | X | |||||
STUDENTPERSON_PROGRAM_INTAKESTATUS_WRITEINTAKE | X | X | X | X | X | X | X | |||||
DATA_ACADEMIC_RESOURCE_CENTER | XXX | DATA_ACADEMIC_RESOURCE_CENTERPERSON_READ | X | X | X | X | X | |||||
DATAPERSON_COUNSELINGRISK_SERVICESREAD | XXX | DATA_COUNSELING_SERVICESX | X | X | X | X | X | |||||
DATAPERSON_SEARCH_DISABILITYREAD | XXXX | DATA_DISABILITYX | X | X | X | X | ||||||
DATAPERSON_DISPLACEDSTRENGTH_WORKERSDELETE | XXX | DATA_DISPLACED_WORKERSX | X | X | X | X | ||||||
DATAPERSON_EARLYSTRENGTH_ALERTREAD | XXX | DATA_EARLY_ALERTX | X | X | X | X | ||||||
DATAPERSON_ENGLISHSTRENGTH_SECOND_LANGAGEWRITE | XXXX | X | X | X | X | |||||||
PERSON_TASK_DELETE | X | X | X | DATA_EVERYONEX | XXX | X | ||||||
PERSON_TASK_READ | X | X | X | X | X | |||||||
DATAPERSON_FASTTASK_FORWARDWRITE | XXX | DATA_FAST_FORWARDX | X | X | X | X | ||||||
DATAPERSON_INDIVIDUALIZEDWATCHLIST_LEARNING_PLANDELETE | XXXX | INDIVIDUALIZED LEARNING PLANX | X | X | ||||||||
DATAPERSON_WATCHLIST_MANAGERREAD | XXXX | X | X | X | X | |||||||
DATAPERSON_MYWATCHLIST_RECORD_ONLYWRITE | XXXX | X | X | X | ||||||||
DATAPERSON_STAFFWRITE | X | XXXX | X | X | X | X | X | |||||
PERSONREFERENCE_READ | XXXX | X | X | X | XX | X | X | |||||
PERSONREFERENCE_WRITE | XXXX | XX | X X | X X | ||||||||
REFERENCEREPORT_READ | XXXX | XX | X X | X | X | REFERENCE_WRITE | XXX | |||||
SELF_HELP_GUIDE_ADMIN_DELETE | X | X | X | |||||||||
PERSON_INSTRUCTIONSELF_HELP_GUIDE_ADMIN_READ | XXXX | X | ||||||||||
SELF_HELP_GUIDE_ADMIN_WRITE | X | X | X X | |||||||||
STUDENT_ | KEYINTAKE_READ | XXXX | X | X | X | X | API | |||||
STUDENT_ | KEYINTAKE_WRITE | X | XXXX | X | X | X |
These are the default role permissions provided by SSP. In order to identify the current permissions in an installed environment, the following query is a good starting point.
Code Block |
---|
select g.group_name, p.activity
from up_group g join up_permission p on substring(p.principal_key,7,2) = g.group_id
where g.group_name like 'SSP_%' and
p.permission_type != 'DENY' and
p.activity != 'SUBSCRIBE'
order by g.group_name, p.activity |