This section contains objects that are checked during scanning of an MS SQL Server DBMS and the operations executed.
To scan the master object as an unprivileged user, you must grant the VIEW ANY DEFINITION permission.
Before you run a scan, set the value of the show advanced options server configuration parameter to 1 using the sp_configure system procedure. For more information, go to technet.microsoft.com/en-us/library/ms188787.aspx.
Operation | Object |
|---|---|
SELECT | backupmediafamily |
SELECT | sys.dm_exec_sessions |
SELECT | spt_values |
SELECT | sysdatabases |
SELECT | syslogins |
SELECT | sysprocesses |
SELECT | sysremotelogins |
SELECT | sysservers |
SELECT | sysxlogins |
SELECT | syscolumns |
SELECT | syscomments |
SELECT | sysfiles |
SELECT | sysindexes |
SELECT | sysobjects |
SELECT | sysprotects |
SELECT | sysusers |
EXECUTE | sp_get_sqlagent_properties |
EXECUTE | sp_configure |
EXECUTE | sp_get_distributor |
EXECUTE | sp_helpdistpublisher |
EXECUTE | sp_helplinkedsrvlogin |
EXECUTE | sp_helprolemember |
EXECUTE | sp_helprotect |
EXECUTE | sp_helpsrvrolemember |
EXECUTE | sp_MSget_current_activity |
EXECUTE | xp_readerrorlog |
EXECUTE | xp_instance_regread |
EXECUTE | xp_regread |
EXECUTE | xp_enum_oledb_providers |
CREATE TABLE | Temporary tables (for example, #table) |
DROP TABLE | Temporary tables (for example, #table) |