private void Window_Loaded()
{
db = OracleDatabase.Instance;
OracleCommand cmd = db.CreateCommand("ALTER SESSION SET \"_ORACLE_SCRIPT\" = TRUE");
this.UpdateDataGrid();
this.LoadCombobox();
}
private void UpdateDataGrid()
{
db = OracleDatabase.Instance;
OracleCommand cmd = db.CreateCommand("ALTER SESSION SET \"_ORACLE_SCRIPT\" = TRUE");
try
{
DataTable dt = db.Query("SELECT object_schema,object_name,policy_name,policy_column,enabled,sel,ins,upd,del FROM dba_audit_policies");
Policy_table.ItemsSource = dt.DefaultView;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void UpdateDataGrid()
{
db = OracleDatabase.Instance;
OracleCommand cmd = db.CreateCommand("ALTER SESSION SET \"_ORACLE_SCRIPT\" = TRUE");
try
{
DataTable dt = db.Query("SELECT * FROM QT.HOADON");
HOADON_table.ItemsSource = dt.DefaultView;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void UpdateDataGrid()
{
db = OracleDatabase.Instance;
OracleCommand cmd = db.CreateCommand("ALTER SESSION SET \"_ORACLE_SCRIPT\" = TRUE");
try
{
DataTable dt = db.Query("SELECT USERNAME, ACTION, ACTION_NAME, OWNER, EXTENDED_TIMESTAMP, SQL_TEXT FROM DBA_AUDIT_TRAIL WHERE OWNER='QT'");
BasicAudit_table.ItemsSource = dt.DefaultView;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void UpdateDataGrid()
{
db = OracleDatabase.Instance;
OracleCommand cmd = db.CreateCommand("ALTER SESSION SET \"_ORACLE_SCRIPT\" = TRUE");
try
{
DataTable dt = db.Query("SELECT TIMESTAMP,db_user,object_schema,object_name,policy_name,sql_text FROM DBA_FGA_AUDIT_TRAIL ORDER BY TIMESTAMP DESC");
Audit_table.ItemsSource = dt.DefaultView;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}