Blog do Ezequiel SQL Server Insights
EDIT (20-09-2012) - Added several scripting options; does not use SQL Server 2000 system tables anymore.EDIT (11-01-2013) - Fixed issue with permission syntax depending on version (2005 vs. 2008/2012).EDIT (18-03-2013) - Fixed issue with undeclared variable in cursor; Added options for access.
Here is another posting focusing on SQL scripts that may help on everyday DBA tasks, following the series "SQL Swiss Army Knife". This is another example of a script I've been using as a "local machine" bit of a wider DR strategy, in this case generating all logins and their respective server roles. Note that this does not deal with CERTIFICATE_MAPPED_LOGIN and ASYMMETRIC_KEY_MAPPED_LOGIN types.These are the options available:
EDIT (11-01-2013): Fixed issue with generating all logins even when single database was chosen.EDIT (17-05-2015): Fixed duplicate permissions scripted with Procedures/Functions/CLR; Extended object coverage.
I've recently joined the PFE team in Portugal, and one part of the job i like is giving something back to the community. Whenever possible, i will be focusing my posts on SQL scripts that may help on everyday DBA tasks, something in the likes of a "SQL Swiss Army Knife". According to BOL, SQL securables "are the resources to which the SQL Server Database Engine authorization system regulates access".