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