This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing basic commands and default stored procedures to check basic SQL Server Security Audit.
Using below commands, DBA can check necessary details related to roles and users of SQL Server.
Find the version of SQL Server:
1 |
exec xp_msver |
Find the information of database files and locations:
1 |
exec sp_helpfile |
Find all database logins:
1 |
SELECT * FROM sys.syslogins |
Find the information about roles:
1 |
exec sp_helprole |
Find the database level principals:
1 |
exec sp_helpuser |
Find the information about user permissions:
1 |
exec sp_helprotect |