KBI 310444 Enhancement: Security Rule For Checking The Execution Of Security Related SQL Statements In Argent for SQL Server

Version

Argent Advanced Technology 1304-L and above

Date

Friday, 3 May 2013

Summary

Argent Advanced Technology has been enhanced with a new Rule ‘SECURITY_SQL2008_CHECK‘ in Argent for SQL Server to check the execution of security related SQL statements

Technical Background

This Rule checks and alerts on execution of the following commands

CREATE/ALTER/DROP LOGIN

CREATE/ALTER/DROP USER

GRANT

REVOKE

sp_addrolemember

sp_droprolemember

sp_adduser

sp_dropuser

Resolution

N/A