Login Properties

Create Database User

This script is used for drop and create a new or existing user. IF User is already exists in database then first it will dropped and then recreate.

Running SSMS after AD account is disabled

Security Audit Db_DataReader

Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.

Re-generating SQL Server Logins

SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.

How to check SQL Server Authentication Mode using T-SQL and SSMS

Many times developers want to put logic into their code or SSIS/DTS package to check the SQL Server authentication mode. How can this be done programmatically?

Script to grant exec permission to all sps in a db

Script to grant exec permission to all sps in a db

Implicit Permissions Due to Ownership Chaining or Scopes in SQL Server

I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?

Implicit Permissions Due to SQL Server Database Roles

I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?

Script DB Level Permissions v3

Scripts role membership, object-level permissions for all DB users.