Chat now with support
Chat with Support

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

Configuring Privileges on the VMware vSphere Client

To configure privileges for the Collector agent component credentials:
1
On the home page, go to Inventory > Hosts and Clusters.
Figure 1. Click Hosts and Clusters in the Inventory section.
2
Right-click the top (parent) host name on the top left and click Assign Permissions.
Figure 2. Select the parent host name.
3
Select the privilege Read-only from the Assigned Role section.
4
Click Add on the Users and Groups column.
The Select Users and Groups dialog box appears.
5
Select the users and groups to be added to the newly created role.
6
Click OK.

Granting Permissions to SQL Server Users

Permissions are granted on several levels, as detailed in the following sections:
•
Instance-level Permissions
•
Database-level Permissions
•
Object-specific Permissions
The actual granting of permissions is described in Running the Grant Permissions Script

Instance-level Permissions

The following permissions are granted at the instance level:
•
VIEW ANY DEFINITION
•
VIEW SERVER STATE
•
ALTER TRACE—allows carrying out the following operations:
•
Tracing a specific session—the data retrieved by this operation is displayed on the SQL Activity > Sessions > Session Details > Session Trace pane
•
Monitoring deadlocks—the data retrieved by this operation is displayed on the SQL Activity > Deadlocks panel

Database-level Permissions

The following permissions are granted at the database level:
•
CREATE USER—the lowest permission level, which only allows accessing each database. Creation of a new user is not required if a domain group with the appropriate permissions is used.
•
db_datareader—allows creating user-defined SQL queries for monitoring purposes, via the User-defined Collections global administration screen. For details, see User-defined Collections section in Foglight for SQL Server User Guide.
•
db_ddladmin—allows running DBCC commands for indexes. In the lack of such a permission, no data will be retrieved from the following collections:
•
Database Index Density Vectors
•
Database Index Details
•
Database Index Histogram
The data retrieved from these collections is displayed by clicking a specific row on the Databases > Indexes pane.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating