-
Titolo
ApexSQL Trigger and ApexSQL Trigger Viewer – Permissions and requirements -
Descrizione
ApexSQL Trigger and ApexSQL Trigger Viewer – Permissions and requirements -
Risoluzione
Applies to ApexSQL Trigger and ApexSQL Trigger Viewer
Summary This article provides information about required permissions and software requirements for ApexSQL Trigger and ApexSQL Trigger Viewer
Description
Required permissions for application installation The Windows user account used to install ApexSQL Trigger and ApexSQL Trigger Viewer must have Windows administrator permissions
Required permissions for running ApexSQL Trigger and ApexSQL Trigger Viewer
The Windows user account used to run ApexSQL Trigger and ApexSQL Trigger Viewer must have Windows administrator permissions
The ApexSQL Trigger user must be a member of the fixed SQL Server sysadmin role on the SQL Server instance where the audited database is hosted.
SQL server permissions required to run ApexSQL Trigger Viewer on a database:
GRANT SELECT ON[dbo].[AUDIT_LOG_DATA] GRANT SELECT ON[dbo].[AUDIT_LOG_DDL] GRANT SELECT ON[dbo].[AUDIT_LOG_TRANSACTIONS] GRANT EXECUTE ON[dbo].[AUDIT_prc_AggregateReport] GRANT EXECUTE ON[dbo].[AUDIT_prc_StandardReport] GRANT SELECT ON[dbo].[AUDIT_LOG_DDLReport] GRANT EXECUTE ON[dbo].[AUDIT_prc_ReportingStart] GRANT EXECUTE ON[dbo].[AUDIT_prc_ReportingEnd] GRANT EXECUTE ON[dbo].[AUDIT_prc_ReportingAddFilterValue] GRANT EXECUTE ON[dbo].[AUDIT_prc_Analyze] GRANT EXECUTE ON[dbo].[AUDIT_fn_HexToStr] GRANT EXECUTE ON[dbo].[AUDIT_fn_SqlVariantToString]Software requirements ApexSQL Trigger and ApexSQL Trigger Viewer software requirements are specified on the System requirements page.
Hardware requirements Both minimum and recommended hardware requirements for ApexSQL Trigger and ApexSQL Trigger Viewer are the same as described on the Hardware and Software Requirements for Installing SQL Server page.