Kalau menggunakan standard database auditing Pertama : set parameter AUDIT_TRAIL dengan nilai OS atau DB, tergantung lokasi penempatan audit trail nya. Dan ini mengharuskan kita utk restart database.
Setelah itu, set audit option nya, misal: SQL> AUDIT SELECT ON SCOTT.emp; Utk meng-"off" kannya SQL> NOAUDIT SELECT ON SCOTT.emp; cmiiw, Bw --- In [email protected], bima boediman <[EMAIL PROTECTED]> wrote: > > Pak Yulius, > > Database saya masih pada setting default yaitu audit di disable... saya membaca untuk mengaktifkan auditing harus shut down database dahulu... apakah benar? dan Audit all by User_name by access untuk meng-"on" kan audit untuk user tersebut jika untuk "off" kan gimana ya?? trims > > ----- Original Message ---- > From: Herry Yusirwan <[EMAIL PROTECTED]> > To: [email protected] > Sent: Wednesday, May 30, 2007 8:51:15 AM > Subject: RE: [indo-oracle] Re: Transaction History Untuk User > > > > > > > > > > > > > > Terima kasih, pak > > > > ____________ _________ _________ __ > > > > From: indo-oracle@ yahoogroups. com [mailto:indo-oracle@ yahoogroups. com] > > On Behalf Of Yulius Wibowo > > Sent: Tuesday, May 29, 2007 5:06 PM > > To: indo-oracle@ yahoogroups. com > > Subject: [indo-oracle] Re: Transaction History Untuk User > > > > Tergantung dari AUDIT yg diberlakukan > > 1. Standard Database AUDIT (tidak merekam nilai) > > 2. Value-based audit, pakai trigger. > > 3. Fine-Grain Audit, sampai level kolom > > 4. Pakai Log-Miner : utk tracing seluruh transaksi > > 5. Pakai Flashback : Query, Version Query & Transaction > > > > --- In indo-oracle@ yahoogroups. com > > <mailto:indo- oracle%40yahoogr oups.com> , "Herry Yusirwan" > > <herry.yusirwan@ ...> wrote: > > > > > > Dear Pak Yulius, > > > > > > > > > > > > Kemampuan audit di oracle10g sampai mana? > > > > > > Apakah bisa merekam tiap transaksi (update, insert, delete, > > create, dll) > > > yang dilakukan? > > > > > > > > > > > > Terima kasih > > > > > > > > > > > > Rgds, > > > > > > Herry > > > > > > > > > > > > > > > > > > ____________ _________ _________ __ > > > > > > From: indo-oracle@ yahoogroups. com > > <mailto:indo- oracle%40yahoogr oups.com> [mailto:indo- > > [EMAIL PROTECTED] com <mailto:oracle% 40yahoogroups. com> ] > > > On Behalf Of Yulius Wibowo > > > Sent: Tuesday, May 29, 2007 7:32 AM > > > To: indo-oracle@ yahoogroups. com <mailto:indo- oracle%40yahoogr oups.com> > > > > > Subject: [indo-oracle] Re: Transaction History Untuk User > > > > > > > > > > > > Coba pakai fasilitas AUDIT di database Oracle. > > > > > > Bw > > > > > > --- In indo-oracle@ yahoogroups. com > > <mailto:indo- oracle%40yahoogr oups.com> > > > <mailto:indo- oracle%40yahoogr oups.com> , "bimaboediman2" > > > <bimaboediman2@ > wrote: > > > > > > > > Dear Oracle Jedi, > > > > > > > > Gimana ya bisa tau History user tertentu. khususnya command apa > > > aja > > > > yang dia execute. Ada cara juga gak untuk tau siapa saja yang > > Execute > > > > command tertentu?(misal: create Table) thank you for your help > > > > > > > > > > > > Bima Boediman > > > > > > > > > > > > > > > > > > > > > > DISCLAIMER: > > > This Message is confidential; it contents does not constitute a > > commitment by PT. INDONESIA POWER, except where provided for in a > > written agreement between you and PT. INDONESIA POWER. Any > > unauthorized disclosure, use or dissemination of the content, either > > whole or partial, is strictly prohibited. If you are not the > > intended recipient of the message or you have received this > > electronic transmission in error, please notify or contact the > > sender immediately. > > > > > > PT.INDONESIA POWER is subsidiary of PT. PLN PERSERO which operates > > in power generating business. Through its 130 power plants, with a > > total capacity of 8,872 MW, PT.INDONESIA POWER has contributed > > significantly to the Java Bali interconnection system electricity > > supply. PT.INDONESIA POWER operates through its eight generating > > Business Unit (GBU) : Suralaya, Priok, Saguling, Kamojang, Mrica, > > Semarang, Perak Grati, Bali and one maintenance Services business > > unit (MSBU). > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > DISCLAIMER: > > This Message is confidential; it contents does not constitute a commitment by PT. INDONESIA POWER, except where provided for in a written agreement between you and PT. INDONESIA POWER. Any unauthorized disclosure, use or dissemination of the content, either whole or partial, is strictly prohibited. If you are not the intended recipient of the message or you have received this electronic transmission in error, please notify or contact the sender immediately. > > > > PT.INDONESIA POWER is subsidiary of PT. PLN PERSERO which operates in power generating business. Through its 130 power plants, with a total capacity of 8,872 MW, PT.INDONESIA POWER has contributed significantly to the Java Bali interconnection system electricity supply. PT.INDONESIA POWER operates through its eight generating Business Unit (GBU) : Suralaya, Priok, Saguling, Kamojang, Mrica, Semarang, Perak Grati, Bali and one maintenance Services business unit (MSBU). > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > <!-- > > #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} > #ygrp-mlmsg table {font-size:inherit;font:100%;} > #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} > #ygrp-mlmsg pre, code {font:115% monospace;} > #ygrp-mlmsg * {line-height:1.22em;} > #ygrp-text{ > font-family:Georgia; > } > #ygrp-text p{ > margin:0 0 1em 0;} > #ygrp-tpmsgs{ > font-family:Arial; > clear:both;} > #ygrp-vitnav{ > padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} > #ygrp-vitnav a{ > padding:0 1px;} > #ygrp-actbar{ > clear:both;margin:25px 0;white-space:nowrap;color:#666;text- align:right;} > #ygrp-actbar .left{ > float:left;white-space:nowrap;} > .bld{font-weight:bold;} > #ygrp-grft{ > font-family:Verdana;font-size:77%;padding:15px 0;} > #ygrp-ft{ > font-family:verdana;font-size:77%;border-top:1px solid #666; > padding:5px 0; > } > #ygrp-mlmsg #logo{ > padding-bottom:10px;} > > #ygrp-vital{ > background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} > #ygrp-vital #vithd{ > font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text- transform:uppercase;} > #ygrp-vital ul{ > padding:0;margin:2px 0;} > #ygrp-vital ul li{ > list-style-type:none;clear:both;border:1px solid #e0ecee; > } > #ygrp-vital ul li .ct{ > font-weight:bold;color:#ff7900;float:right;width:2em;text- align:right;padding-right:.5em;} > #ygrp-vital ul li .cat{ > font-weight:bold;} > #ygrp-vital a { > text-decoration:none;} > > #ygrp-vital a:hover{ > text-decoration:underline;} > > #ygrp-sponsor #hd{ > color:#999;font-size:77%;} > #ygrp-sponsor #ov{ > padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} > #ygrp-sponsor #ov ul{ > padding:0 0 0 8px;margin:0;} > #ygrp-sponsor #ov li{ > list-style-type:square;padding:6px 0;font-size:77%;} > #ygrp-sponsor #ov li a{ > text-decoration:none;font-size:130%;} > #ygrp-sponsor #nc { > background-color:#eee;margin-bottom:20px;padding:0 8px;} > #ygrp-sponsor .ad{ > padding:8px 0;} > #ygrp-sponsor .ad #hd1{ > font-family:Arial;font-weight:bold;color:#628c2a;font- size:100%;line-height:122%;} > #ygrp-sponsor .ad a{ > text-decoration:none;} > #ygrp-sponsor .ad a:hover{ > text-decoration:underline;} > #ygrp-sponsor .ad p{ > margin:0;} > o {font-size:0;} > .MsoNormal { > margin:0 0 0 0;} > #ygrp-text tt{ > font-size:120%;} > blockquote{margin:0 0 0 4px;} > .replbq {margin:4;} > --> > > > > > > > > > > _____________________________________________________________________ _______________Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. > http://answers.yahoo.com/dir/?link=list&sid=396545433 > > [Non-text portions of this message have been removed] >
