protected override async Task ExecuteStatementAsync(StatementContext context)
{
if (!await context.ObjectExistsAsync(ObjectName))
{
throw new SqlStatementException($"The object '{ObjectName}' is not defined in this scope");
}
var userManager = context.GetUserManager();
var roleManager = context.GetRoleManager();
var grantManager = context.GetGrantManager();
if (await userManager.UserExistsAsync(Grantee))
{
if (!await grantManager.GrantToUserAsync(context.User().Name, Grantee, ObjectName, Privileges, WithGrantOption))
{
throw new SqlStatementException("It was not possible to grant to user because of a system error");
}
}
else if (await roleManager.RoleExistsAsync(Grantee))
{
if (WithGrantOption)
{
throw new SqlStatementException("Cannot set a grant option to a role");
}
if (!await grantManager.GrantToRoleAsync(Grantee, ObjectName, Privileges))
{
throw new SqlStatementException("It was not possible to grant to role because of a system error");
}
}
else
{
throw new SqlStatementException($"The grantee '{Grantee}' was not defined");
}
context.RaiseEvent <ObjectPrivilegesGrantedEvent>(context.User().Name, Grantee, ObjectName, Privileges, WithGrantOption);
}