Chatta subito con l'assistenza
Chat con il supporto

Foglight for SQL Server 5.7.5.1 - Foglight for SQL Server 5.7.5.1 Getting Started Guide

Object-specific Permissions

The permissions listed below allow users holding them to access specific objects within the master and msdb databases:
•
Execute—allows accessing the following objects within the master database:
•
xp_enumerrorlogs
•
xp_readerrorlog
•
Select—allows accessing the following objects within the msdb database:
•
log_shipping_monitor_primary
•
log_shipping_monitor_secondary
•
log_shipping_primaries
•
log_shipping_secondaries
•
sysalerts
•
syscategories
•
sysjobactivity
•
sysjobs
•
sysjobhistory
•
dbm_monitor_data
•
dbm_monitor (Relevant only when replication is used)

Running the Grant Permissions Script

The file used for granting permissions manually, SQLServerGrantPrivilegesScript.sql, can be downloaded clicking the link View script under the Instances table, accessible via one of the following methods:
•
At the end of the installation process, when the Status column of the instance table displays the status: Insufficient database privileges, clicking this text brings up the Insufficient Database Privileges dialog box. For details, see the Advanced Instance Installation Wizard topic in the Managing SQL Server Database Systems User and Reference Guide.
•
In the Connection Details global administration screen, if some of the instances whose verification failed display a status of either Insufficient privileges, Click to Grant, or Wrong sysdba Credentials, clicking this text brings up the Insufficient Database Privileges dialog box. For details, see Global Administration > Connection Details in the Managing SQL Server Database Systems User and Reference Guide).
The Insufficient Database Privileges dialog box allows you to specify a SYSAdmin (System Administrator) user with sufficient privileges. Enter a SYSAdmin user and password, and then click Grant Privileges. Alternatively, click the View script link, to the right of the Grant privileges button, to grant privileges manually by means of a script.
To manually run the Grant Permissions script:
1
Go to Dashboards > Administration > Cartridges > Components for Download.
2
Double-click DB_SQL_Server_Cli_Installer.
3
Click Download.
4
Extract the DB_SQL_Server_Cli_Installer.zip file.
5
Copy the following lines:
•
MSSQLPermissionsCheck.sql
•
MSSQLPermissionsGrant.sql
6
Open the SQLServerGrantPrivilegesScript.sql file in SQL Server Management Studio (SSMS).
7
Find the Select @LoginName = ? section in the beginning of this file.
8
Replace the question mark with the login name to which the requested permissions are to be assigned.
9
Execute the script.
* 
IMPORTANT: Repeat step 1 to step 4 for each instance to be monitored.
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione