private void Delete_Grant()
{
DataTable temp = (DataTable)Priv_dataGridView.DataSource;
foreach (DataRow dr in temp.Rows)
{
string table_name = dr["OWNER"].ToString() + "." + dr["TABLE_NAME"].ToString();
Oracle.revoke_priv(MainForm.Login_Form.conn, table_name, MainForm.username, "DELETE");
}
foreach (DataRow dr in temp.Rows)
{
if (Convert.ToBoolean(dr["ENABLED"]))
{
string table_name = dr["OWNER"].ToString() + "." + dr["TABLE_NAME"].ToString();;
if (Convert.ToBoolean(dr["WITH GRANT OPTION"]))
{
Oracle.Grant_Delete(MainForm.Login_Form.conn, table_name, MainForm.username, true);
}
else
{
Oracle.Grant_Delete(MainForm.Login_Form.conn, table_name, MainForm.username, false);
}
}
}
}
private int Update_Grant()
{
DataTable temp = (DataTable)Priv_dataGridView.DataSource;
foreach (DataRow dr in temp.Rows)
{
if ((dr["COLUMN_NAME"].ToString().ToUpper() == "LUONG" || dr["COLUMN_NAME"].ToString().ToUpper() == "PHUCAP") && this.Table_name == "LUONG")
{
MessageBox.Show("CỘT " + dr["COLUMN_NAME"].ToString().ToUpper() + "ĐÃ ĐƯỢC MÃ HÓA, KHÔNG ĐƯỢC PHÉP ADD QUYỀN SELECT QUA APP!!", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(0);
}
}
MainForm.Login_Form.conn.Open();
Oracle.revoke_priv(MainForm.Login_Form.conn, Table_name, MainForm.username, "UPDATE");
foreach (DataRow dr in temp.Rows)
{
if (Convert.ToBoolean(dr["ENABLED"]))
{
if (Convert.ToBoolean(dr["WITH GRANT OPTION"]) && MainForm.is_user)
{
Oracle.Grant_Update(MainForm.Login_Form.conn, dr["COLUMN_NAME"].ToString(), Table_name, MainForm.username, true);
}
else
{
Oracle.Grant_Update(MainForm.Login_Form.conn, dr["COLUMN_NAME"].ToString(), Table_name, MainForm.username, false);
}
}
}
MainForm.Login_Form.conn.Close();
return(1);
}
private void Update_Grant()
{
MainForm.Login_Form.conn.Open();
DataTable temp = (DataTable)Priv_dataGridView.DataSource;
Oracle.revoke_priv(MainForm.Login_Form.conn, Table_name, MainForm.username, "UPDATE");
foreach (DataRow dr in temp.Rows)
{
if (Convert.ToBoolean(dr["ENABLED"]))
{
if (Convert.ToBoolean(dr["WITH GRANT OPTION"]))
{
Oracle.Grant_Update(MainForm.Login_Form.conn, dr["COLUMN_NAME"].ToString(), Table_name, MainForm.username, true);
}
else
{
Oracle.Grant_Update(MainForm.Login_Form.conn, dr["COLUMN_NAME"].ToString(), Table_name, MainForm.username, false);
}
}
}
}
private int Delete_Grant()
{
DataTable temp = (DataTable)Priv_dataGridView.DataSource;
// CHECK XEM CÓ BẢNG NÀO THUỘC DẠNG EXCEPTION KHÔNG, NẾU CÓ BÁO ERROR (DO CHƯA CÓ CÁCH XỬ LÍ)
foreach (DataRow dr in temp.Rows)
{
if (Convert.ToBoolean(dr["ENABLED"]) && dr["TABLE_NAME"].ToString() == "LUONG")
{
MessageBox.Show("BANG " + dr["TABLE_NAME"].ToString().ToUpper() + "ĐÃ ĐƯỢC MÃ HÓA, KHÔNG ĐƯỢC PHÉP ADD QUYỀN SELECT QUA APP!!", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(0);
}
}
MainForm.Login_Form.conn.Open();
foreach (DataRow dr in temp.Rows)
{
string table_name = dr["OWNER"].ToString() + "." + dr["TABLE_NAME"].ToString();
Oracle.revoke_priv(MainForm.Login_Form.conn, table_name, MainForm.username, "DELETE");
}
foreach (DataRow dr in temp.Rows)
{
if (Convert.ToBoolean(dr["ENABLED"]) && MainForm.is_user)
{
string table_name = dr["OWNER"].ToString() + "." + dr["TABLE_NAME"].ToString();;
if (Convert.ToBoolean(dr["WITH GRANT OPTION"]))
{
Oracle.Grant_Delete(MainForm.Login_Form.conn, table_name, MainForm.username, true);
}
else
{
Oracle.Grant_Delete(MainForm.Login_Form.conn, table_name, MainForm.username, false);
}
}
}
MainForm.Login_Form.conn.Close();
return(1);
}
