RSS

Daily Archives: October 15, 2012

Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers

Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers

Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have access to. This was a little more difficult to accomplish because security is different on different servers and I did not want to create Linked Servers with escalated permissions. Read only SQL users was an option, however there is no good way to make sure that these users will have read permissions on all current and future databases. It took a while to over come these challenges but I got it working; obviously since I have this blog post.

You can read Part 1 here if you haven’t yet.

Read the rest of this entry »

Advertisements
 

Tags: , , , , ,

 
%d bloggers like this: