|
|
|
Script out all Database Security
|
Links to a script in the Migration Toolkit that generates comprehensive scripts for all DB security objects and associated server logins, with passwords encrypted
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Enumerate Logins mapped via Groups
|
Get a list of domain logins that have access to the current server via domain group membership
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Fix Orphaned Users in a Database
|
Fix all orphaned logins in a database.
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Generate a database security report
|
This is a really helpful report that produces a comprehensive web page that can be used to document the security on a server.
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Get List of Impersonated Rights
|
Get a list of impersonation rights granted at a Server level.
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Server Permissions Audit
|
Lists all Server and Database roles on the server, along with their member logins and users
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Get List of Failed Login Attempts
|
Parse the SQL Error Log files for failed logins.
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Change SQL Agent Job Owner
|
Change the owner of an existing SQLAgent job
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Generate Script for Database Permissions
|
A lightweight scripting of database level permissions
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Create Application Roles using TSQL
|
Create application roles using TSQL
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
Get List of Users with 'sa' Priveleges
|
Get a list of server users with 'sa' priveleges
|
2000, 2005, 2008, 2008R2, 2012
2014, 2016, 2017
|
|
|
|