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)

7,065 reads

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

I developed these rules a while back, before COVID. I had a period of...

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

Comments posted to this topic are about the item The SQL Server MCP Server

Comments posted to this topic are about the item The Hidden Danger of Wildcard...

Comments posted to this topic are about the item A Worse Computer; A Better...

How do I get an MCP server for my SQL Server 2025 database from Microsoft?