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