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

Enumerate Logins mapped via Groups - Get a list of domain logins that have access to the current server via domain group membership

Fix Orphaned Users in a Database - Fix all orphaned logins in a database.

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.

Get List of Impersonated Rights - Get a list of impersonation rights granted at a Server level.

Server Permissions Audit - Lists all Server and Database roles on the server, along with their member logins and users

Get List of Failed Login Attempts - Parse the SQL Error Log files for failed logins.

Change SQL Agent Job Owner - Change the owner of an existing SQLAgent job

Generate Script for Database Permissions - A lightweight scripting of database level permissions

Create Application Roles using TSQL - Create application roles using TSQL

Get List of Users with 'sa' Privileges - Get a list of server users with 'sa' privileges