Posts Tagged 'Database Permissions'

Listing explicitly granted database persmissions (SQL Server)

I recently needed to know what explicit permissions had been granted to some tables and sprocs in one of my databases, and wasn’t able to find a way to do it through the SQL Management Studio UI.  So I googled, and found this query:

explicitly granted db permissions

(Code)


Scott’s recent tweets…