Assigning permissions to the stored procedure - Johnson Controls - LIT-12012431 - Software Application - OpenBlue Enterprise Manager - 4.0

OpenBlue Enterprise Manager Data Collector Installation Guide

Product
Building Automation Systems > Building Automation Systems > OpenBlue Enterprise Manager
Document type
Installation Guide
Document number
LIT-12012431
Version
4.0
Revision date
2021-11-29

Procedure

  1. Expand the Databases section in the Object explorer window.
  2. Expand the JCIHistorianDB database on the SQL Server.
  3. Expand Programmability.
  4. Expand Stored Procedures.
  5. Right-click on the stored procedure dbo.spu_GetTrendSamples and select Properties, then select Permissions.
  6. Click on the search button and a new window opens.
  7. Click on the Browse button, select the new read-only user account that you just created, and click OK.
  8. Select Grant for the EXECUTE permission in the Permission window, and click OK.
  9. Select Log out in the SQL Server Management Studio page.