Quick script to drop a user from all databases. This does not drop the schema if said user owns one. It will error if the user owns a schema. This also uses SQLPSX. Use at your own risk.
Import-Module SqlServer $serverName = 'ServerName' $loginToRemove = 'LoginOrUserName' $dbs = Get-SqlDatabase -sqlserver $serverName | where{$_.IsSystemObject -eq $false} foreach($db in $dbs) { foreach($user in $db.Users | where{$_.Name -eq $loginToRemove}) { $user.Drop(); } }
One thought on “Powershell Script to drop a User from all Databases”