SQL 2005 - List Permission

This script will list user permissions for database objects.

Tracking Illicit Users

Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.

Basic SQL Server security principles you can't afford to miss

Learn how using basic SQL Server security practices of least privilege, delegated administration and separation of duties will protect SQL Server databases.

SQL Server 2005 Encryption types

SQL Server 2005 provides four methods of encryption. Part one of this article covers encryption and decryption by passphrase.

SQL Server encryption vs. hashing for data security

Study encryption and hashing algorithm options for data security in SQL Server 2005 and use symmetric/asymmetric keys to encrypt and decrypt SQL Server data.

OpenRowset Security

Reorganize permissions in SQL Server 2005 step by step

Learn how to reorganize permissions in SQL Server 2005 in a multiple database environment.

Server Login/Role And DB User/Role Script

This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results

OpenRowset Security

GrantExecAllUserAllSpandfunctions.sql

Grant permits execution to all user on all sp and functions