Skip to content

February 12, 2013

1

Powershell Script to drop a User from all Databases

by Scott Newman

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();
	}
}
Read more from Powershell, SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Note: HTML is allowed. Your email address will never be published.

Subscribe to comments

%d bloggers like this: