sp_SrvPermissions V2.0

1

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.
sp_SrvPermissions

About these ads

One thought on “sp_SrvPermissions V2.0

  1. […] 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 […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 348 other followers

%d bloggers like this: