Hi,

I have around 10-15 sql server's where i have to verify access among multiple db's in those servers.

What would be the best and automated way to do it?

Can we use any batch files to do it. i need a sample for this please.

One way is to use powershell to execute t-sql script against servers to check this

see

http://realsqlguy.com/automated-permissions-auditing-with-powershell-and-t-sql-part-1/

http://realsqlguy.com/automated-permissions-auditing-with-powershell-and-t-sql-part-2/

http://realsqlguy.com/automated-permissions-auditing-with-powershell-and-t-sql-part-3/

https://msdn.microsoft.com/en-us/library/bb895144.aspx