Transform your SQL Server permissions

SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.

Introduction to SQL Server Security — Part 2

In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting permissions to users, logins, and groups.

Granting View Definition Permission to a User or Role in SQL Server

In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function.

Granting CONTROL permission on a database

Setting Permissions to Drop a Database

Learn which permissions are required to drop a database and see a test to show that these apply.

Viewing Plans

SQL Server Access Control: The Basics

No technology yet invented can in any way allow us to neglect the task of ensuring the security of the database by controlling access. Security must be applied in depth, and the database is designed provide a system that will thwart even the most determined external attack. If it seems a bit complicated at first, that is no longer an excuse now that Rob Sheldon has provided this simple guide for getting started.

Grant > Deny?

Script DB Level Permissions v4.3

Script database and object level permissions for all database users

CONNECTing to SQL Server