RVY200614 Create the user for the RayVentory Database connection for SmartTrack

 

To retrieve the inventory information collected by RayVentory via SmartTrack, you need to create a SQL user to read the data. The data is stored in the "RayVentoryDataHubResult" database, so a read permission for this database is required.  

 

Note: If you renamed the database during the installation of RayVentory DataHub, the database will have a different name.  

 

Create User Login

General

Login Name <LoginName>
SQL Server authentication
Enforce password policy
Default Database RayVentoryDataHubResult
Default Language English

 

Server Roles

public

 

User mapping

Map Database User Default Schema
RayVentoryDataHubResult <UserName> dbo

 

Database role membership for: RayVentoryDataHubResult

public
db_datareader

 

Status

Permission to connect to the database engine

Grant

 

Login

Enabled

 

EXECUTE Permission

Run in a query

use ManageSoft

grant execute to <UserName>

 

Changelog

  • 18.08.2020, Heiko Brune: Creation of the document
  • 16.04.2021, Mesut Yel: Updated information

Comments

Powered by Zendesk