private void RemoveFromDb(Database db, SqlUserBase sub)
{
try
{
User u = db.Users[sub.Name];
//u.Drop();
}
catch (FailedOperationException foe)
{
base.ThrowInnerException(foe);
}
}
private SmoUser AddToDb(Database db, SqlUserBase sub)
{
var user = new User(db, sub.Name);
try
{
user.Create();
}
catch (FailedOperationException foe)
{
base.ThrowInnerException(foe);
}
return(user);
}
protected override void EndProcessing()
{
for (int i = 0; i < _users.Count; i++)
{
SqlUserBase sub = _users[i];
IEnumerable <Database> _onlyThese = _dbs.Where(x => x.Users.Contains(sub.Name));
foreach (Database db in _dbs)
{
if (this.Force || base.ShouldProcess(db.Name + " within " + _server.Name, "Removing " + sub.Name))
{
this.RemoveFromDb(db, sub);
}
}
}
base.Refresh(_dbs);
}
protected override void EndProcessing()
{
for (int i = 0; i < _users.Count; i++)
{
SqlUserBase sub = _users[i];
foreach (Database db in _dbs)
{
if (base.ShouldProcess(db.Name + " within " + _server.Name, "Adding " + sub.Name))
{
SmoUser user = this.AddToDb(db, sub);
base.WriteObject(user);
}
}
}
base.Refresh(_dbs);
}
protected private SqlUserBase GetUser(string userName)
{
return(_server.Logins.Contains(userName)
? SqlUserBase.ConvertFromSql(_server.Logins[userName])
: null);
}
