Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs

TechNet Gallery - resources for IT professionals

Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.

Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by: rss
3 results in Security > Olaf Helper [Clear]
List Database Roles and Members with Server Login
Olaf Helper
This Transact-SQL script list all roles of the current database with their members. Additonal the associated SQL Server login is listed.
(6)
Updated 9/15/2011
Released 9/15/2011
1,274 Downloads
SQL
Secure Orphaned User AutoFix
Olaf Helper
This Transact-SQL statement links orphaned user like "sys.sp_change_users_login" to existing principals with same name, but in regard of security this script don't add a new principal if none with same name was found; as the SP with option AUTO_FIX do.
(4)
Updated 9/8/2011
Released 9/8/2011
1,469 Downloads
SQL
List all Server Permissions
Olaf Helper
This Transact-SQL script list all server principals with their permissions on server level to give a quick overview of security. For given permissions on server object like endpoints or impersonate other login it returns also the object / login etc name.
(3)
Updated 10/12/2011
Released 10/12/2011
1,105 Downloads
SQL