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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.5 (2)

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

3,957 reads

I was reminded this week that I needed to get registered for the Data...

Today’s coping tip is to choose to see your mistakes as steps to help...

Good day reader. This post is coming to you from a busy week in...

We have change tracking enabled on one of our databases and I am looking...

I have two databases on the same server. I have a service account I...

Hi, I'm trying to run the below SQL code but I'm getting this error:...