database - Audit on oracle schema for dml statements -
i need secure oracle user doing inserts/updates/deletes outside programs written me.
i googled bit around find need. know can use own written db triggers. , there 2 major systems oracle (at least found). can use fine grained auditing. , can use audit trail.
i think in case audit trail comes close isn't looking for. because need program connection db coming. example need register connections doing inserts/updates/deletes there statements executed coming sql developer or toad. other connections may pass without audit.
on daily basis have lots of connections registering overload.
i hope 1 of have idea on how set up.
regards
you can use product of oracle: oracle audit vault , database firewall. because want know program connection comes, need database firewall. can monitor traffic through database, specifying ip address , client connection started. can specify if want audit dml or ddl,or other statements. data stored locally in product's database,not in secure target (your database). have look, it need: http://www.oracle.com/technetwork/products/audit-vault-and-database-firewall/overview/overview-1877404.html
Comments
Post a Comment