コード例 #1
0
ファイル: Grant_privs.cs プロジェクト: dbhuy2268/bvien
        private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                //GRANT MỊN TRÊN CỘT, FLAG == 3 LÀ USER, FLAG == 4 LÀ ROLE
                if (flag == 3 || flag == 4)
                {
                    // grant update(malichtruc) on lichtruc to ACCMASTER;
                    // dataGridView2[4, e.RowIndex].Value.ToString()
                    if (e.ColumnIndex == 0) //SELECT
                    {
                        List <string> kq = get_CurrentViewStatus();
                        if (kq.Contains(dataGridView2[4, e.RowIndex].Value.ToString()))
                        {
                            DialogResult res = MessageBox.Show("DA TON TAI VIEW VOI QUYEN NAY. REVOKE?", "REVOKE?", MessageBoxButtons.YesNo);
                            if (res == DialogResult.Yes)
                            {
                                kq.Remove(dataGridView2[4, e.RowIndex].Value.ToString());
                                string query_revoke = "CREATE OR REPLACE VIEW " + (flag == 3 ? Cur_user : Cur_role) + "_" + tableName + " as " + "select ";
                                for (int i = 1; i < kq.Count - 1; i++)
                                {
                                    query_revoke += kq[i] + ", ";
                                }

                                query_revoke += kq[kq.Count - 1];
                                query_revoke += " from " + tableName;

                                DBUtils dbu = new DBUtils();

                                if (kq.Count == 1)
                                {
                                    query_revoke = "DROP VIEW " + (flag == 3 ? Cur_user : Cur_role) + "_" + tableName;
                                }
                                MessageBox.Show(query_revoke);
                                if (dbu.ExecuteNonQuery(query_revoke))
                                {
                                    MessageBox.Show("REVOKE THANH CONG");
                                    privcs.loadDT();
                                    if (flag == 1 || flag == 3)
                                    {
                                        privcs.LoadUserObjPriv_gridView();
                                    }
                                    if (flag == 2 || flag == 4)
                                    {
                                        privcs.LoadRoleObjPriv_gridView();
                                    }
                                    return;
                                }
                                MessageBox.Show("REVOKE THAT BAI");
                            }
                            return;
                        }
                        kq.Add(dataGridView2[4, e.RowIndex].Value.ToString());
                        string query = " VIEW " + (flag == 3 ? Cur_user : Cur_role) + "_" + tableName + " as " + "select ";
                        for (int i = 1; i < kq.Count - 1; i++)
                        {
                            query += kq[i] + ", ";
                        }

                        query += kq[kq.Count - 1];
                        query += " from " + tableName;

                        grant_revoke_objectPriv grant_Revoke_ObjectPriv = new grant_revoke_objectPriv(this, privcs, query, Cur_user, Cur_role, (flag == 4 ? 6 : 5), tableName);
                        grant_Revoke_ObjectPriv.ShowDialog();
                    }
                    if (e.ColumnIndex == 1 || e.ColumnIndex == 2)
                    {
                        MessageBox.Show("KHONG HO TRO INSERT VA DELETE MIN TREN COT");
                        return;
                    }

                    if (e.ColumnIndex == 3) //UPDATE
                    {
                        string query = " UPDATE(" + dataGridView2[4, e.RowIndex].Value.ToString() + ") on " + tableName;

                        grant_revoke_objectPriv grant_Revoke_ObjectPriv = new grant_revoke_objectPriv(this, privcs, query, Cur_user, Cur_role, flag);
                        grant_Revoke_ObjectPriv.ShowDialog();
                    }
                }
                else
                {
                    if (e.ColumnIndex == 0) //SELECT
                    {
                        string query = " SELECT ON " + dataGridView2[5, e.RowIndex].Value.ToString() + "." + dataGridView2[4, e.RowIndex].Value.ToString();
                        grant_revoke_objectPriv grant_Revoke_ObjectPriv = new grant_revoke_objectPriv(this, privcs, query, Cur_user, Cur_role, (flag == 2 ? 4 : 3));
                        grant_Revoke_ObjectPriv.ShowDialog();
                    }
                    if (e.ColumnIndex == 1) //INSERT
                    {
                        string query = " INSERT ON " + dataGridView2[5, e.RowIndex].Value.ToString() + "." + dataGridView2[4, e.RowIndex].Value.ToString();
                        grant_revoke_objectPriv grant_Revoke_ObjectPriv = new grant_revoke_objectPriv(this, privcs, query, Cur_user, Cur_role, (flag == 2 ? 4 : 3));
                        grant_Revoke_ObjectPriv.ShowDialog();
                    }
                    if (e.ColumnIndex == 2) //DELETE
                    {
                        string query = " DELETE ON " + dataGridView2[5, e.RowIndex].Value.ToString() + "." + dataGridView2[4, e.RowIndex].Value.ToString();
                        grant_revoke_objectPriv grant_Revoke_ObjectPriv = new grant_revoke_objectPriv(this, privcs, query, Cur_user, Cur_role, (flag == 2 ? 4 : 3));
                        grant_Revoke_ObjectPriv.ShowDialog();
                    }
                    if (e.ColumnIndex == 3) //UPDATE
                    {
                        string query = " UPDATE ON " + dataGridView2[5, e.RowIndex].Value.ToString() + "." + dataGridView2[4, e.RowIndex].Value.ToString();
                        grant_revoke_objectPriv grant_Revoke_ObjectPriv = new grant_revoke_objectPriv(this, privcs, query, Cur_user, Cur_role, (flag == 2 ? 4 : 3));
                        grant_Revoke_ObjectPriv.ShowDialog();
                    }
                }
            }
            catch (Exception ex)
            {
                return;
            }
        }
コード例 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (flag != 5 && flag != 6)
            {
                q = qq;
                q = "GRANT" + q + " TO " + ((flag == 3) ? cUser : cRole);
                DialogResult res = MessageBox.Show("WITH GRANT OPTION?", "Grant option", MessageBoxButtons.YesNo);

                if (res == DialogResult.Yes)
                {
                    q = q + " with grant option";
                }

                MessageBox.Show(q);

                DBUtils dbu = new DBUtils();
                if (dbu.ExecuteNonQuery(q))
                {
                    MessageBox.Show("GRANT THANH CONG");
                    papaformpriv.loadDT();
                    if (flag == 1 || flag == 3)
                    {
                        papaformpriv.LoadUserObjPriv_gridView();
                    }
                    else
                    {
                        papaformpriv.LoadRoleObjPriv_gridView();
                    }
                    this.Close();

                    return;
                }
                MessageBox.Show("GRANT THAT BAI");
            }

            else
            {
                q = qq;
                q = "CREATE OR REPLACE " + q;
                string qGrant = "GRANT SELECT ON " + ((flag == 5) ? cUser : cRole) + "_" + tabName + " TO " + ((flag == 5) ? cUser : cRole);

                DialogResult res = MessageBox.Show("WITH GRANT OPTION?", "Grant option", MessageBoxButtons.YesNo);

                if (res == DialogResult.Yes)
                {
                    qGrant = qGrant + " with grant option";
                }

                MessageBox.Show(q);
                MessageBox.Show(qGrant);
                DBUtils dbu = new DBUtils();
                if (dbu.ExecuteNonQuery(q))
                {
                    DBUtils dbu1 = new DBUtils();
                    if (dbu1.ExecuteNonQuery(qGrant))
                    {
                        MessageBox.Show("GRANT THANH CONG");
                    }
                    papaformpriv.loadDT();
                    if (flag == 5)
                    {
                        papaformpriv.LoadUserObjPriv_gridView();
                    }
                    if (flag == 6)
                    {
                        papaformpriv.LoadRoleObjPriv_gridView();
                    }
                    this.Close();

                    return;
                }
                MessageBox.Show("GRANT THAT BAI");
            }
        }