Module Signatures

Script to determine permissions in SQL Server 2005

Although a few different options (Management Studio, system stored procedures, system views, custom scripts, etc.) exist to determine your permissions in SQL Server, in this tip we want to outline the functionality from the fn_my_permissions table valued function.

Script permissions on all databases

i took the core from a script found in the site for generating permissions and update it.

Application Roles

Create_sp_help_revlogin_DB

Enhanced sp_help_revlogin

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.