Re: audit access

look at the AUDIT schema_objects entry in the SQL Reference manual for basic auditing info for tables, and other objects

DDL triggers will help if you need to track or control specifics about who is modifying object structure (but not DML)

good old DML triggers can help if you need details about table modifications

it gets trickier if you need to audit who is looking at what specific data -- i'm not aware of any way to do an AFTER SELECT trigger, you'd probably need to do something within a stored procedure -- but hopefully that's not the requirement!

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1067492071.750730_at_yasure...
> E S wrote:
>
> >I want to see who are doing changes to a tabel, and was wondering how to
do
> >this. I am using "audit create session;" on the server now. How will the
> >command for audit access to a table be? I hopede something like "audit
> >create access on tabel;" would work.
> >
> >
> >
> Go to http://tahiti.oracle.com and look up "DDL Triggers"
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Thu Oct 30 2003 - 09:47:16 CST