Insert staff classification/scope records into the Descriptor Mapping table. Part of the Row-Level Security Collection.
analytics_config.rls_InsertStaffClassificationDescriptorScope
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
Contents