Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

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

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