//Revoke role cho user
public CapQuyen Revoke_Role_To_User_In_Database(CapQuyen cq)
{
OracleConnection conn = Connect();
OracleCommand orc = new OracleCommand();
orc.Connection = conn;
orc.CommandText = "sp_revoke_role_user";
orc.Parameters.Add(new OracleParameter("username", OracleDbType.Varchar2)).Value = $"{cq.username}";
orc.Parameters.Add(new OracleParameter("name_privs", OracleDbType.Varchar2)).Value = $"{cq.name_privs}";
orc.CommandType = System.Data.CommandType.StoredProcedure;
orc.ExecuteNonQuery();
conn.Close();
return(cq);
}
//Revoke quyen cho role
public CapQuyen Revoke_privs_Role(CapQuyen capquyen)
{
var respon = new DAL();
return(respon.Revoke_Priv_Role_In_Database(capquyen));
}
//Revoke role cua user
public CapQuyen Revoke_Role_To_User(CapQuyen capquyen)
{
var respon = new DAL();
return(respon.Revoke_Role_To_User_In_Database(capquyen));
}
//Grant quyen cho user
public CapQuyen Grant_privs(CapQuyen capquyen)
{
var respon = new DAL();
return(respon.Grant_Priv_In_Database(capquyen));
}
