public async Task ExecutePrivileged()
{
var requirements = new RequirementCollection();
requirements.Require(ObjectName.Parse("sys.tab1"), SqlPrivileges.Insert);
SqlStatement statement = new TestStatement {
Requirements = requirements,
Location = new LocationInfo(0, 0)
};
statement = await statement.PrepareAsync(context);
await statement.ExecuteAsync(context);
}
public async Task ExecuteWithBadprivileges()
{
var requirements = new RequirementCollection();
requirements.Require(ObjectName.Parse("sys.tab1"), SqlPrivileges.Alter);
SqlStatement statement = new TestStatement {
Requirements = requirements,
Location = new LocationInfo(0, 0)
};
statement = await statement.PrepareAsync(context);
await Assert.ThrowsAnyAsync <UnauthorizedAccessException>(() => statement.ExecuteAsync(context));
}
