Security Boundary SQL Scripts

Application Roles

• authoriser.ApplicationRole.sql
• configurator.ApplicationRole.sql
• controller.ApplicationRole.sql
• editor.ApplicationRole.sql
• reader.ApplicationRole.sql

Schemas

• authorising.Schema.sql
• internal.Schema.sql
• user_restr.Schema.sql

Authorising Stored Procedures

• authorising.usp_AUTHORISE_contr_dc_grp_usr.StoredProcedure.sql
• authorising.usp_AUTHORISE_contr_fl_grp_usr.StoredProcedure.sql
• authorising.usp_AUTHORISE_doc_group_viewer.StoredProcedure.sql
• authorising.usp_AUTHORISE_form_group_owner.StoredProcedure.sql
• authorising.usp_AUTHORISE_user_role.StoredProcedure.sql
• authorising.usp_DEL_contr_doc_group_name.StoredProcedure.sql
• authorising.usp_DEL_contr_doc_group_sid.StoredProcedure.sql
• authorising.usp_DEL_contr_file_group_name.StoredProcedure.sql
• authorising.usp_DEL_contr_file_group_sid.StoredProcedure.sql
• authorising.usp_DEL_doc_group_viewer_perm.StoredProcedure.sql
• authorising.usp_DEL_form_group_owner.StoredProcedure.sql
• authorising.usp_DEL_sid.StoredProcedure.sql
• authorising.usp_DEL_user_role.StoredProcedure.sql
• authorising.usp_INS_contr_doc_group_name.StoredProcedure.sql
• authorising.usp_INS_contr_file_group_name.StoredProcedure.sql
• authorising.usp_INS_grant_authoriser.StoredProcedure.sql
• authorising.usp_INS_revoke_authoriser.StoredProcedure.sql
• authorising.usp_UPD_cancel_authoriser_requ.StoredProcedure.sql
• authorising.usp_UPD_contr_doc_group_name.StoredProcedure.sql
• authorising.usp_UPD_contr_doc_group_sid.StoredProcedure.sql
• authorising.usp_UPD_contr_file_group_name.StoredProcedure.sql

Controlling Stored Procedures

• controlling.usp_DEL_contr_doc_group_link.StoredProcedure.sql
• controlling.usp_DEL_contr_file_group_link.StoredProcedure.sql
• controlling.usp_DEL_doc_gp_ed_perm_funct.StoredProcedure.sql
• controlling.usp_DEL_doc_gp_ed_perm_people.StoredProcedure.sql
• controlling.usp_DEL_doc_group_name_rstr.StoredProcedure.sql
• controlling.usp_DEL_duty_function.StoredProcedure.sql
• controlling.usp_DEL_duty_function_sid_link.StoredProcedure.sql
• controlling.usp_DEL_file_gp_ed_perm_funct.StoredProcedure.sql
• controlling.usp_DEL_file_gp_ed_perm_people.StoredProcedure.sql
• controlling.usp_DEL_file_group_name.StoredProcedure.sql
• controlling.usp_DEL_function_list.StoredProcedure.sql
• controlling.usp_DEL_function_list_name.StoredProcedure.sql
• controlling.usp_DEL_people_list.StoredProcedure.sql
• controlling.usp_DEL_people_list_name.StoredProcedure.sql
• controlling.usp_DEL_restricted_form_id.StoredProcedure.sql
• controlling.usp_DEL_tag_br_tr_perm_flist.StoredProcedure.sql
• controlling.usp_DEL_tag_br_tr_perm_plist.StoredProcedure.sql
• controlling.usp_DEL_tag_group_perm_flist.StoredProcedure.sql
• controlling.usp_DEL_tag_group_perm_plist.StoredProcedure.sql
• controlling.usp_DEL_tag_tree_perm_flist.StoredProcedure.sql
• controlling.usp_DEL_tag_tree_perm_plist.StoredProcedure.sql
• controlling.usp_INS_contr_doc_group_link.StoredProcedure.sql
• controlling.usp_INS_contr_file_group_link.StoredProcedure.sql
• controlling.usp_INS_doc_gp_ed_perm_funct.StoredProcedure.sql
• controlling.usp_INS_doc_gp_ed_perm_people.StoredProcedure.sql
• controlling.usp_INS_doc_group_name.StoredProcedure.sql
• controlling.usp_INS_duty_function.StoredProcedure.sql
• controlling.usp_INS_duty_function_sid_link.StoredProcedure.sql
• controlling.usp_INS_file_gp_ed_perm_funct.StoredProcedure.sql
• controlling.usp_INS_file_gp_ed_perm_people.StoredProcedure.sql
• controlling.usp_INS_file_group_name.StoredProcedure.sql
• controlling.usp_INS_function_list.StoredProcedure.sql
• controlling.usp_INS_function_list_name.StoredProcedure.sql
• controlling.usp_INS_people_list.StoredProcedure.sql
• controlling.usp_INS_people_list_name.StoredProcedure.sql
• controlling.usp_INS_tag_br_tr_perm_flist.StoredProcedure.sql
• controlling.usp_INS_tag_br_tr_perm_plist.StoredProcedure.sql
• controlling.usp_INS_tag_group_perm_flist.StoredProcedure.sql
• controlling.usp_INS_tag_group_perm_plist.StoredProcedure.sql
• controlling.usp_INS_tag_tree_perm_flist.StoredProcedure.sql
• controlling.usp_INS_tag_tree_perm_plist.StoredProcedure.sql

Internal Stored Procedures

• internal.usp_AUTHENTICATE_authoriser.StoredProcedure.sql
• internal.usp_AUTHENTICATE_cont_doc_grp.StoredProcedure.sql
• internal.usp_AUTHENTICATE_cont_file_grp.StoredProcedure.sql
• internal.usp_AUTHENTICATE_doc_ed_perm.StoredProcedure.sql
• internal.usp_AUTHENTICATE_doc_grp_ed_pm.StoredProcedure.sql
• internal.usp_AUTHENTICATE_file_ed_free.StoredProcedure.sql
• internal.usp_AUTHENTICATE_file_ed_perm.StoredProcedure.sql
• internal.usp_AUTHENTICATE_fl_grp_ed_pm.StoredProcedure.sql
• internal.usp_AUTHENTICATE_tag_br_tree.StoredProcedure.sql
• internal.usp_AUTHENTICATE_tag_edit.StoredProcedure.sql
• internal.usp_AUTHENTICATE_tag_group.StoredProcedure.sql
• internal.usp_AUTHENTICATE_tag_tree.StoredProcedure.sql
• internal.usp_AUTHENTICATE_user_doc_grp.StoredProcedure.sql
• internal.usp_AUTHENTICATE_user_doc_id.StoredProcedure.sql
• internal.usp_AUTHENTICATE_user_file_id.StoredProcedure.sql
• internal.usp_AUTHENTICATE_user_form.StoredProcedure.sql
• internal.usp_AUTHENTICATE_user_role.StoredProcedure.sql
• internal.usp_AUTHENTICATE_wf_inst_step.StoredProcedure.sql
• internal.usp_AUTHENTICATE_wf_instance.StoredProcedure.sql
• internal.usp_AUTHORISE_authoriser.StoredProcedure.sql
• internal.usp_REVOKE_authoriser.StoredProcedure.sql
• internal.usp_SEL_message.StoredProcedure.sql

Reading Stored Procedures

• reading.usp_CHECK_doc_ed_permission.StoredProcedure.sql
• reading.usp_CHECK_file_ed_permission.StoredProcedure.sql
• reading.usp_INS_self_onboard_sid.StoredProcedure.sql

Tables — messaging schema

• messaging.message_details.Table.sql

Tables — people schema

• people.duty_function_sid_links.Table.sql
• people.duty_functions.Table.sql
• people.function_list_names.Table.sql
• people.function_lists.Table.sql
• people.people_list_names.Table.sql
• people.people_lists.Table.sql

Tables — user_restr schema

• user_restr.authorisation_fail_log.Table.sql
• user_restr.authoriser_privilege_requests.Table.sql
• user_restr.authorisers.Table.sql
• user_restr.controller_doc_group_sid_links.Table.sql
• user_restr.controller_file_grp_sid_links.Table.sql
• user_restr.doc_group_edit_perm_funct_lst.Table.sql
• user_restr.doc_group_edit_perm_people_lst.Table.sql
• user_restr.doc_group_view_permissions.Table.sql
• user_restr.file_group_edit_perm_funct_lst.Table.sql
• user_restr.form_group_owners.Table.sql
• user_restr.role_list.Table.sql
• user_restr.sid_list.Table.sql
• user_restr.tag_br_tree_permissions_flist.Table.sql
• user_restr.tag_br_tree_permissions_plist.Table.sql
• user_restr.tag_group_permissions_flist.Table.sql
• user_restr.tag_group_permissions_plist.Table.sql
• user_restr.tag_tree_permissions_flist.Table.sql
• user_restr.tag_tree_permissions_plist.Table.sql
• user_restr.user_privilege_log.Table.sql
• user_restr.user_privilege_revoke_log.Table.sql
• user_restr.user_role_link.Table.sql

Tables — xref schema

• xref.controller_doc_group_names.Table.sql
• xref.controller_file_group_names.Table.sql
• xref.doc_group_names.Table.sql
• xref.file_group_names.Table.sql