INSERT permission denied on object ‘AUDIT_LOG_TRANSACTIONS’ error is shown

Applies to
ApexSQL Trigger

Summary
Triggers were successfully created on the tables, but upon populating the tables with data the following errors are seen:

“INSERT permission denied on object ‘AUDIT_LOG_TRANSACTIONS’, database ‘My_Database’, owner ‘dbo’.”

Cause
Insufficient permissions on writing audit log

Resolution
Each audit trigger executes with permissions of the parent table owner. The table owners should have “write” permissions on the ApexSQL Trigger storage tables.

To grant insert permissions to your tables see the code below:

INSERT ON[DBO].[AUDIT_LOG_TRANSACTIONS]
TO [TABLE_OWNER]
GO

GRANT
INSERT
ON[DBO]style="color: silver;">.[AUDIT_LOG_DATA]
TO[TABLE_OWNER]
GO

table_owner is the table owner or a role

About ApexSQL Trigger
ApexSQL Trigger is a SQL Server auditing tool, which tracks data changes in SQL Server databases using triggers. ApexSQL Trigger allows you to audit database access by login, host and application name

Last updated
July 20, 2012