Tag Info

New answers tagged

0

You can use custom policies or predefined ones (so called best practices) and adjust them according to your developer SQL Server instance. Then, as explained in the SQL Server Policy Based Management – evaluating policies on multiple SQL Server instances online article, evaluate them against (even multiple) production instances


0

Idera SQL Permissions Extractor seems to be the product you're looking for. It can script server and object permissions and it is free. There is also a commercial edition, called SQL Secure which has more features. The feature comparison between the two editions can be found here.



Top 50 recent answers are included