Cool Tips‎ > ‎

SQL Server Security

 


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

 

 


Comments