SQL Server 2012: Create audit failed (user permission)

Asked Mar 20 '18 at 12:16

Active Mar 20 '18 at 12:23

Viewed 171 times

I am logged in SQL Server 2012 as db_owner user, I am trying to create an Audit but I receive this error:

User does not have permission to perform this action

What kind of permission does the user need? And how I can assign the new permission to the user?

EDIT

Tried that :

USE master;
GO
GRANT ALTER ANY SERVER AUDIT TO AuditConfigurationLogin

But I cant change permissions to myself:

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

edited Mar 20 '18 at 12:23

asked Mar 20 '18 at 12:16

aggicd

Permission "ALTER ANY SERVER AUDIT"? – Leo Chapiro Mar 20 '18 at 12:26
@duDE tried but I cant update the permissions of myself – aggicd Mar 20 '18 at 12:27
Have you tried REVOKE ALTER ANY SERVER AUDIT ? – Leo Chapiro Mar 20 '18 at 12:31
@dude can you provide the full command? – aggicd Mar 20 '18 at 12:46

0 Answers0