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