//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)); }