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,977 reads

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

I had an idea for an animated view of a sales tool, and started...

Comments posted to this topic are about the item GPX distance and time analysis...

Comments posted to this topic are about the item The DBA is Dead; Long...

Comments posted to this topic are about the item Changing the AG Listener

In SQL Server 2025, if I want to remove an IP from a listener, what do I do?