Search SSWUG.ORG:



DATABASES

Clean Up SQL Server Logins and Users with PowerShell This is an off-site link.  Please review our Terms of Service for additional information.




(Allen White) Unless you've got a well-defined strategy to manage SQL Server logins and database users via Active Directory groups (as I usually recommend when setting up SQL Server security), you're going to eventually find yourself in a situation where you'll need to clean up logins that don't have access to any database and database users that don't have an associated login.

Read this article...







comments powered by Disqus