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)

You rated this post out of 5. Change rating

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

4,845 reads

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

A customer asked about how they could organize their migration scripts in different ways...

Recently I got a message that my Evernote subscription was going up. It’s been...

I have a production server with SQL server 2016 version (13.0.5026.0) and a database...

I am trying to use unpivot to extract some data, however, the results are...

hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...