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:
log_shipping_monitor_secondary |
Granted for Log Shipping monitoring Granted for Jobs and Replication monitoring |
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. |
If you are using DB2 LUW, ensure that these permissions are set.
Set Account Privileges on:
Grant Select privilege on:
Grant Execute on:
*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:
• |
Foglight for Azure SQL can be used for granting permissions on several levels.
The following permissions are required at the database level:
|
The following permissions are required at the elastic pool level:
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:
• |
When running the Monitor Azure SQL Database wizard, the script link is in the Insufficient Privileges dialog screen. |
• |
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. |
4 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center