Application Roles

Login error is really what?

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.