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();
}
}
Advertisements
Pingback: Remove Database User & Login via powershell | SqlServerPowershell