public void ShortDescriptionTest()
{
GrantExecuteToPublicPolicy target = new GrantExecuteToPublicPolicy();
string actual;
actual = target.ShortDescription;
Assert.AreEqual("Check for GRANT .. TO [public]", actual);
}
public void LongDescriptionTest()
{
GrantExecuteToPublicPolicy target = new GrantExecuteToPublicPolicy();
string actual;
actual = target.LongDescription;
Assert.AreEqual("Checks that scripts do not GRANT any privileges to the [public] group", actual);
}
public void PolicyIdTest()
{
GrantExecuteToPublicPolicy target = new GrantExecuteToPublicPolicy();
string actual;
actual = target.PolicyId;
string expected = "GrantExecuteToPublicPolicy";
Assert.AreEqual(actual, expected);
}
public void CheckPolicyTest_PublicGrantNoBracket()
{
GrantExecuteToPublicPolicy target = new GrantExecuteToPublicPolicy();
string script = UnitTest.Properties.Resources.PublicGrant_nobracket;
string message = string.Empty;
string messageExpected = "Script contains a GRANT statement to the [public] group";
bool expected = false;
bool actual;
System.Collections.Generic.List <System.Text.RegularExpressions.Match> commentCollection = ScriptHandling.ScriptHandlingHelper.GetScriptCommentBlocks(script);
actual = target.CheckPolicy(script, commentCollection, out message);
Assert.AreEqual(messageExpected, message);
Assert.AreEqual(expected, actual);
}
public void CheckPolicyTest_NoPublicGrant()
{
GrantExecuteToPublicPolicy target = new GrantExecuteToPublicPolicy();
string script = UnitTest.Properties.Resources.NonPublicGrant;
string message = string.Empty;
string messageExpected = string.Empty;
bool expected = true;
bool actual;
System.Collections.Generic.List <System.Text.RegularExpressions.Match> commentCollection = ScriptHandling.ScriptHandlingHelper.GetScriptCommentBlocks(script);
actual = target.CheckPolicy(script, commentCollection, out message);
Assert.AreEqual(messageExpected, message);
Assert.AreEqual(expected, actual);
}