public static bool isUserMemberOf(String userName, string groupName, IQueryService qrySrvc)
{
string query = string.Format(
"SELECT i_all_users_names FROM dm_group WHERE group_name = '{0}' AND ANY i_all_users_names = '{1}'",
groupName, userName);
QueryResult queryResult = DfsHelper.executePassThrough(qrySrvc, query);
if (queryResult.DataObjects.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="userName"></param>
/// <param name="groupName"></param>
/// <param name="qrySvc"></param>
public static void removeUserFromGroup(string userName, string groupName, IQueryService qrySvc)
{
string query = string.Format("ALTER GROUP '{0}' DROP '{1}'", groupName, userName);
QueryResult queryResult = DfsHelper.executePassThrough(qrySvc, query);
}