September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The fixes are listed at the bottom of the comments block.
sp_SrvPermissions is a stored procedure that will output 3 record sets containing information on the server level principals, what roles they belong to and what explicit permissions they have.
NOTE: I’ve removed the code and put in a link to the latest version.