0
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.
Permission "ALTER ANY SERVER AUDIT"? – duDE – 2018-03-20T12:26:56.550
@duDE tried but I cant update the permissions of myself – aggicd – 2018-03-20T12:27:39.190
Have you tried REVOKE ALTER ANY SERVER AUDIT ? – duDE – 2018-03-20T12:31:59.423
@dude can you provide the full command? – aggicd – 2018-03-20T12:46:37.000