The Source Code - Multilevel Security for Relational Databases - page 242

globals.UserLabel + “]
values(“ + name + “,” +
Class + “,” + Dept + “,”
+ Class +”,” + Salary +
“,” + Class+ “)”;
Glo balClasses.DBOperations.
SetData(DStr);
}
else if (SmithBTN.Checked)
{
string DStr = “insert into dbo.
[Smith-Employee] values(“ + name
+ “,” + Class + “,” + Dept + “,”
+ Salary + “,” + Class + “)”;
Glo balClasses.DBOperations.
SetData(DStr);
}
if (MLRBTN.Checked)
{
string DStr = “insert into dbo.
[Employee] values(“ + name + “,”
+ Class + “,” + Dept + “,” +
Class + “,” + Salary + “,” +
Class + “,” + Class + “)”;
Glo balClasses.DBOperations.
SetData(DStr);
}
if (EncryptionBTN.Checked)
{
string DStr = “exec dbo.
usp _ EnableCellVisibility;
insert into dbo.[Employee]
values(ENCRYPTBYKEY(KEY _
GUID('” + Label +
“SymmetricKey'),'” + name
+ “'),” +
“ENCRYPTBYKEY(KEY _ GUID('”
+ Label +
“SymmetricKey'),'” + Dept
+ “'),” +
“ENCRYPTBYKEY(KEY _ GUID('”
+ Label +
“SymmetricKey'),'” +
Salary + “'),” + Class+
“)”;