public ActionResult Delete(long scId, string user, string objname, string policy)
{
JsonResult ret = new JsonResult();
try
{
//查询语句结尾不要逗号，否则报错:ORA-00911: 无效字符
using (OracleDAL dal = new OracleDAL(GetSessionConnStr(scId)))
{
dal.ExecuteProcedureNonQuery("dbms_fga.drop_policy",
new OracleParameter("object_schema", user),
new OracleParameter("object_name", objname),
new OracleParameter("policy_name", policy));
}
ret.Data = JsonConvert.SerializeObject(new
{
status = 0,
message = ""
});
}
catch (Exception ex)
{
ret.Data = JsonConvert.SerializeObject(new
{
status = 1,
message = ex.Message
});
RecordException(ex);
}
return(ret);
}
