Next Integration (Concilio) - SQL User Creation Setup

Overview

This article provides an overview of how to create a User within SQL & set permissions, so that the User only has access to SQL stored procedures created for Next Interface.

Prerequisites

The Operator should be able to access SQL Server Management Studio and have permission to create a User
Prior to creation of User role, please execute the stored procedures present in the Next Integration (Concilio) - SQL Stored Procedure Creation article

Next Integration (Concilio)

Bepoz interface with Concilio allows to send Till Summary information from Bepoz to Concilio

Creating a SQL User for Concilio After logging into SQL Server Management Studio, select the appropriate DatabaseSelect 'Security' and then right click on 'Users' to click on 'New User' option from the dropdown list

A Database User - New window appears, select 'General' from the options on the left and set the 'User type' to 'SQL User without login' and 'User name' to 'Concilio'Now, select 'Securables' from the options on the left and click on the 'Search' button

Select 'Specific objects...' and click 'OK' Select 'Object Types' and select 'Stored procedures' and hit the 'OK' button

Select Browse to enter the object names to select and within the list of objects, search for the saved stored procedures of 'ConcilioData' and 'ConcilioMapping' and click on the 'OK' button

Grant the User the permission to 'Execute' for both dbo.ConcilioData and dbo.ConcilioMapping

With this setting in place, the user can only access and execute the Concilio stored procedures