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

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...

In the United States, today is Thanksgiving. The intent behind the holiday is to...

Comments posted to this topic are about the item Don't Let Corner Cases Drive...

Comments posted to this topic are about the item A New Operator

Comments posted to this topic are about the item Troubleshooting Common SQL Server Errors:...

In SQL Server 2025, what does this code return?

SELECT '1' || '0'