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

OpenBlue Enterprise Manager Data Collector Installation Guide

Brand
Johnson Controls
Product name
OpenBlue Enterprise Manager
Document type
Installation Guide
Document number
LIT-12012431
Version
4.0
Revision date
2021-11-29
Language
English

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.