Skip to main content

rls_InsertStaffClassificationDescriptorScope Stored Procedure

Purpose​

Insert staff classification/scope records into the Descriptor Mapping table. Part of the Row-Level Security Collection.

SQL Object​

analytics_config.rls_InsertStaffClassificationDescriptorScope

Usage​

Map staff with classification code value  "Counselor" to the "Section" scope of permissions:

exec [analytics_config].[InsertStaffClassificationDescriptorScope] @StaffDescriptor = 'Counselor', @Scope = 'Section'

-- alternate, using Id values
exec [analytics_config].[InsertStaffClassificationDescriptorScope] @StaffDescriptorId = 154, @ScopeId = 1