Application.Configuration_RemoveRowLevelSecurity
Documentation | WideWorldImporters |
Schema | Application |
Name | Configuration_RemoveRowLevelSecurity |
Script
CREATE PROCEDURE [Application].Configuration_RemoveRowLevelSecurity WITH EXECUTE AS OWNER AS BEGIN SET NOCOUNT ON; SET XACT_ABORT ON; DECLARE @SQL nvarchar(max); BEGIN TRY; SET @SQL = N'DROP SECURITY POLICY IF EXISTS [Application].FilterCustomersBySalesTerritoryRole;'; EXECUTE (@SQL); SET @SQL = N'DROP FUNCTION IF EXISTS [Application].DetermineCustomerAccess;'; EXECUTE (@SQL); PRINT N'Successfully removed row level security'; END TRY BEGIN CATCH PRINT N'Unable to remove row level security'; THROW 51000, N'Unable to remove row level security', 1; END CATCH; END; |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51