public IActionResult RevokeRoleFromUser(GrantRoleToUserViewModel model)
{
using (var ole = new OracleConnection(config.GetConnectionString("DefaultConnection")))
{
ole.Query <string>($@"REVOKE {model.GrantedRole} FROM {model.Username}");
return(RedirectToAction(nameof(SysController.ListRolePrivsUser), "Sys"));
}
}
public IActionResult GrantRoleToUser(string id, [FromQuery] string username)
{
using (var ole = new OracleConnection(config.GetConnectionString("DefaultConnection")))
{
var vmGrantRoleToUser = new GrantRoleToUserViewModel();
vmGrantRoleToUser.GrantedRole = id;
var users = ole.Query <string>(@"SELECT DISTINCT USERNAME FROM sys.dba_users");
vmGrantRoleToUser.Users = users.Select(x =>
{
return(new SelectListItem()
{
Text = x,
Value = x
});
});
vmGrantRoleToUser.Username = username;
return(View(vmGrantRoleToUser));
}
}
