New User-defined Server Roles.
However, one limitation of the user-defined server roles is that they cannot be granted permission on database level securables.
The following script demonstrates
how to create a server role named ServerAudit_Admins, configures the role with
permission to modify server audits only. Members of this role will be able to
modify existent server audits, but won’t be able to create nor drop a server
CREATE SERVER ROLE [ServerAudit_Admins] AUTHORIZATION [sa];
GRANT ALTER ANY SERVER AUDIT TO [ServerAudit_Admins];
ALTER SERVER ROLE [ServerAudit_Admins] ADD MEMBER [jperez];
.Send mail to
questions or comments about this web site.