|
<< Click to Display Table of Contents >> Raynet One Data Hub > 14.0 u1 > Administration and User Guide > Appendices Appendix III: Required Permissions for RayVentory Server Database |
In order to run tasks from Raynet One Data Hub on the RayVentory Server Database it is necessary to grant execution privileges to the following stored procedures:
•csp_aspera_connector_device
•csp_aspera_connector_device_provider_types
•csp_aspera_connector_device_providers
•csp_aspera_connector_device_relation
•csp_aspera_connector_device_relation_types
•csp_aspera_connector_device_types
•csp_aspera_connector_software_arp
•csp_aspera_connector_software_file
•csp_aspera_connector_software_generic_microsoft
•csp_aspera_connector_software_generic_oracle
•csp_aspera_connector_software_generic_os
•csp_aspera_connector_software_generic_othersw
•csp_aspera_connector_software_generic_unixspecial
•csp_aspera_connector_software_msi
•csp_aspera_connector_tag
•CompUsage
•sp_OracleInstances
•sp_rp_OracleVirtualInfrastructure
•f_HardwareProperties
The following .sql script can be executed on the RayVentory database in order to grant the necessary execution rights for all tasks:
GRANT EXECUTE ON csp_aspera_connector_device TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_device_provider_types TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_device_providers TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_device_relation TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_device_relation_types TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_device_types TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_arp TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_file TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_generic_microsoft TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_generic_oracle TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_generic_os TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_generic_othersw TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_generic_unixspecial TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_msi TO [AIO\serviceUserDB] GRANT EXECUTE ON csp_aspera_connector_software_tag TO [AIO\serviceUserDB] GRANT EXECUTE ON CompUsage TO [AIO\serviceUserDB] GRANT EXECUTE ON sp_OracleInstances TO [AIO\serviceUserDB] GRANT EXECUTE ON sp_rp_OracleVirtualInfrastructure TO [AIO\serviceUserDB]
GRANT SELECT ON f_HardwareProperties TO [AIO\serviceUserDB] |