FactoryLogix Learning
FactoryLogix Learning
Breadcrumbs

Grant SQL stored procedure permissions

KB Article administrator on-premise only

Overview

This script grants execute permissions on required FactoryLogix stored procedures to a specified SQL user. Run this script after creating a new FactoryLogix database or adding a new service account.

Procedure

  1. Open SQL Server Management Studio (SSMS) and open a New Query window.

  2. Paste the script below into the query window.

  3. Edit the following variables to match your environment: set @UserName to the SQL user (for example, [DOMAIN\FLXSvc]) and set @DB to the target database name.

  4. Execute the script. 

Declare @dbName nvarchar(50)
Declare @UserName nvarchar(75)
SET @dbName = 'Test'
SET @UserName = '[JKEEN\FLXSvc]'

Declare @SQL nvarchar(max);
select @SQL = 'USE ' + @dbName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::CheckoutBatchDataCollectionDocumentLink TO ' + @UserName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::CreateArchiveQueue TO ' + @UserName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::DeleteECAD TO ' + @UserName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::FinishBatchRouteTransaction TO ' + @UserName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::FinishRerouteProcessFlowTransactionStatuses TO ' + @UserName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::GenerateSerialNumberDefinition TO ' + @UserName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::StartBatchRouteStatus TO ' + @UserName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::StartBatchRouteTransaction TO ' + @UserName;
EXEC (@SQL);
select @SQL = 'GRANT EXECUTE ON OBJECT::StartRerouteProcessFlowTransactionStatuses TO ' + @UserName;
EXEC (@SQL);