Captain DBA

Find Deny permissions on database objects

This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2015-01-14 (first published: 2014-12-17)

6,995 reads

Every organization I talk to has the same problem dressed up in different clothes....

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...

Ten years (and a couple jobs) ago, I wrote about naming default constraints to...

Comments posted to this topic are about the item The day-to-day pressures of a...

Comments posted to this topic are about the item The Problem Isn't Always Your...

Comments posted to this topic are about the item Identity Defaults

What happens when I run this code?

CREATE TABLE dbo.IdentityTest
(
     id int IDENTITY(10) PRIMARY KEY,
     somevalue VARCHAR(20)
)
GO