rls_RemoveStaffClassificationDescriptorScope Stored Procedure

Owned by Stephen Fuqua

Apr 26, 2020

1 min read

Purpose

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

SQL Object

analytics_config.rls_RemoveStaffClassificationDescriptorScope

Usage

Remove mapping for classification code value "Counselor" to the "Section" scope of permissions:

exec [analytics_config].[RemoveStaffClassificationDescriptorScope] (@StaffDescriptor = 'Counselor', @Scope = 'Section')

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

Contents