Scribd
Upload
48 views3 pages

EY SQL Server Script

This SQL audit script runs several stored procedures to retrieve information about the database server configuration, roles, logins, and databases. The procedures return details on the SQL version, server roles and members, database roles and members, logins, devices, and alerts.

Uploaded by

ochedikwujonah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
48 views3 pages

EY SQL Server Script

This SQL audit script runs several stored procedures to retrieve information about the database server configuration, roles, logins, and databases. The procedures return details on the SQL version, server roles and members, database roles and members, logins, devices, and alerts.

Uploaded by

ochedikwujonah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 3

/*

############################################################
# Auditor Name : EY
# Audit Date : January 2020
# Description : MS SQL Database audit script
############################################################
*/
print
'==============================================================================='
print '======SELECT @@version====='
go
SELECT @@version
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPSRVROLEMEMBER (sysadmin)======'
go
EXEC sp_helpsrvrolemember 'sysadmin'
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPSRVROLEMEMBER (serveradmin)======'
go
EXEC sp_helpsrvrolemember 'serveradmin'
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPSRVROLEMEMBER (securityadmin)======'
go
EXEC sp_helpsrvrolemember 'securityadmin'
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPROLEMEMBER======'
go
sp_helprolemember
go

use master
print
'==============================================================================='
print '======SELECT name FROM sysdatabases======'
go
SELECT name FROM sysdatabases
go

print
'==============================================================================='
print '======Stored procedure: SP_DBFIXEDROLEPERMISSION======'
go
sp_dbfixedrolepermission
go

print
'==============================================================================='
print '======SELECT * FROM sys.sql_logins======'
go
SELECT * FROM sys.sql_logins
go

print
'==============================================================================='
print '======SELECT * FROM sys.sql_logins======'
go
sp_configure
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPDEVICE======'
go
sp_helpdevice
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPREMOTELOGIN======'
go
SP_HELPREMOTELOGIN
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPROLEMEMBER (db_owner)======'
go
sp_helprolemember 'db_owner'
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPROLEMEMBER (db_securityadmin)======'
go
sp_helprolemember 'db_securityadmin'
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPROLEMEMBER (db_accessadmin)======'
go
sp_helprolemember 'db_accessadmin'
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPROTECT======'
go
EXEC sp_helprotect
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPUSER======'
go
EXEC sp_helpuser
go

use msdb
print
'==============================================================================='
print '======Stored procedure: SP_HELP_ALERT======'
go
EXEC sp_help_alert
go

print
'==============================================================================='
print '======Stored procedure: SP_HELPROLEMEMBER======'
go
sp_helprolemember
go

You might also like