Chatee ahora con Soporte
Chat con el soporte

Foglight for Sybase 6.1.0.10 - Deployment Guide

Permissions for SQL Server databases

If you are using SQL Server®, ensure that these permissions are set.

* Creation of a new user is not required if a domain group with the appropriate permissions is used.

** It's permission for Amazon RDS for SQL Server.

Grant Execute on these master database objects:

Grant Select on these msdb database objects:

 

Permissions for SAP ASE databases

If using non-sa user, ensure the following:

Procedures need to be manually created on the monitored instance. This is achieved by manually downloading and running the scripts DB_Sybase_FirstRun_Scripts located under Foglight > Dashboards > Administration > Agents > Cartridges > Components for Download. Refer to the Foglight For SAP ASE Release Notes for more details.

Permissions for DB2 for LUW databases

If you are using DB2 LUW, ensure that these permissions are set.

Set Account Privileges on:

Grant Select privilege on:

Grant Execute on:

Required Monitor Switches

*Should be set to at least the base level.

Grant Select on these SYSIBMADM administrative views:

* For DB2 version 9.7.0.5 or later

Grant Execute on to these table functions:

Grant Select on these views:

Permissions for Azure SQL Database

Foglight for Azure SQL can be used for granting permissions on several levels.

The following sections detail the permissions that can be granted to users of Azure SQL at each level, and instruct how to manually run the grant privileges script.

The following permissions are granted at the database level:

IMPORTANT:

On the DTU model:

Basic, Standard 0, and Standard 1 tiers require server admin permission or an Azure Active Directory admin account (VIEW SERVER STATE permission).

The file used for granting permissions manually, SQLAzureGrantPrivilegesScript.sql, can be downloaded by clicking the link View script under the Instances table, accessible via either of the following methods:

In the Cartridges - Components for Download screen.
2
Open the DBSS_Azure_Permissions_User_Databases.sql file in SQL Server Management Studio (SSMS).
3
Find the Select @LoginName = ? section at the beginning of this file.
Documentos relacionados
Foglight for Sybase - 6.1.0.10
Deployment Guide
Release Notes
Third Party Contributions
User and Reference Guide
Showing 1 to 4 of 4 rows

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación