rls_InsertStaffClassificationDescriptorScope Stored Procedure

Owned by Stephen Fuqua

Apr 26, 2020

1 min read

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

Contents