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

There's a great article from MIT Technology Review about resetting on the hype of...

etherness – n. the wistful feeling of looking around a gathering of loved ones,...

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Comments posted to this topic are about the item Your Value from a Conference

Comments posted to this topic are about the item UNISTR Basics

What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)

SELECT UNISTR('Hello 4E16754C') AS 'A Classic';