Cryptography

Grant Mass permissions

Create A role and grant it a permission on a DB Schemas.

Blocking Users by IP

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.

List all permissions in all databases

This script will allow you get all the users and roles with permission on objects on all databases.

SQL Server Encryption Key Management between Development, Test and Production Environments

The company I work for has decided to use the encryption technology available in SQL Server 2005. We have almost everything ironed out except for which keys to use in the development, testing, and production environments. Should we use one key for all three environments or different keys for each?

Determine Users with Permission on an Object

This script will walk the hierarchical chain of users and roles to find users with permissions on an object.

Securing SQL with access control and login monitoring

SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.

Securing SQL Server with access control and login

SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.

Security issues when using aliased users in SQL Server

This tip shows you how to find security holes when aliased users are setup in your databases and also that this feature will be deprecated in SQL Server 2008.

SQL Server security settings using the Surface Area Configuration tool (SAC)

Are any tools available to secure SQL Server independent of the logins and users that I have in place? Do I need to manage SQL Server on each machine or can I do so from a single application?