Applicable Versions: v2.X6.0
ACCESS | ROLES | ||||||||||
NAME | TOOL | CONFIDENTIALITY LEVELPermission/Role | SSP_ADMINISTRATOR | SSP_COACH | SSP_DEVELOPER | SSP_FACULTY | SSP_MANAGER | SSP_MAP_TEMPLATE_ADMIN | SSP_STUDENT | SSP_SUPPORT_STAFF | |
---|---|---|---|---|---|---|---|---|---|---|---|
PERSON_CHALLENGE_DELETE | ACTION PLANACCOMMODATION_READ | X | X | X | X | ||||||
ACCOMMODATION_WRITE | X | X | X | X | PERSON | ||||||
API_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 | PERSON_GOAL_DELETE | ACTION PLAN | ||||
BULK_WATCHLIST_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 | SECOND_LANGUAGE | X | X | |||||||
DATA_EVERYONE | X | X | X | X | X | X | PERSON_TASK_READ | ||||
ACTION PLANDATA_FAST_FORWARD | X | X | |||||||||
DATA_INDIVIDUALIZED_LEARNING_PLAN | X | 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_READ | CASELOAD MANAGEMENTX | 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_READ | CASELOAD MANAGEMENTX | X | X | X | |||||||
PERSON_DOCUMENT_WRITE | X | X | X | XX | |||||||
PERSON_EARLY_ALERT_DELETEEARLY ALERT | X | X | X | X | |||||||
PERSON_EARLY_ALERT_READEARLY ALERT | X | X | X | X | XX | X | |||||
PERSON_EARLY_ALERT_RESPONSE_DELETEEARLY ALERT | X | X | X | X | |||||||
PERSON_EARLY_ALERT_RESPONSE_READEARLY ALERT | X | X | X | X | X | ||||||
PERSON_EARLY_ALERT_RESPONSE_WRITEEARLY ALERT | X | X | X | X | X | ||||||
PERSON_EARLY_ALERT_WRITE | EARLY ALERT | X | X | X | X | XX | X | ||||
PERSON_JOURNAL_ENTRY_DELETEJOURNALFILTERED_READ | X X | X | X | ||||||||
PERSON_JOURNAL_ENTRY_READJOURNALFILTERED_WRITE | X | ||||||||||
PERSON_GOAL_DELETE | X | X | X | X | X | ||||||
PERSON_JOURNAL_ENTRY_WRITE | JOURNAL | GOAL_READ | X | X | X | X | X | ||||
PERSON_TEST_READ | MAIN | GOAL_WRITE | X | X | X | X | X | ||||
PERSON_TRANSCRIPTINSTRUCTION_READ | MAINX | X | X | X | X | X | |||||
PERSON_JOURNAL_DOCUMENTENTRY_DELETE | STUDENT DOCUMENTSX | X | XX | X | X | X | |||||
PERSON_DOCUMENTJOURNAL_ENTRY_READ | STUDENT DOCUMENTSX | X | XX | X | X | X | |||||
PERSON_JOURNAL_DOCUMENTENTRY_WRITE | STUDENT DOCUMENTSX | X | XX | X | X | X | |||||
PERSON_LEGACY_ | WATCHLISTREMARK_READ | CASELOAD ASSIGNMENTX | X | X | XX | ||||||
PERSON_LEGACY_ | WATCHLISTREMARK_WRITE | CASELOAD ASSIGNMENTX | X | X | XX | ||||||
PERSON_ | WATCHLISTMAP_ | DELETEREAD | CASELOAD ASSIGNMENTX | X | X | XX | ROLE | ||||
PERSON_ | ACCOMMODATIONMAP_ | READWRITE | ACCOMMODATIONSX | X | X | XX | 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 | X | XXXX | 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 |