Re: how to set a audit trail in oracle 8160, 8170 and 806

Not possible.

Well, what I should say is that a single solution is not available.

You can set audit_trail=db, and then do something like 'audit frank;', and then every time Frank exercises a privilege (select, insert, delete, update etc), a record will be written into the AUD$ table (and there are a bunch of data dictionary views to help you interrogate the audit trail without having to access that table directly). But you won't know *what* Frank selected, deleted or updated. You'll get records that say things like 'Frank exercised the delete from emp privilege'. So you know he deleted something, but not the specifics.

Next, you could turn to Log Miner (or at least, you could if you've got at least version 8i -but we don;t know that, because you neglected to tell us). That will allow you to see precisely what and when Frank deleted, inserted or updated. But you can't see what he selected.

To audit Frank's log ons, you want an 'after logon on database' trigger that says something like 'if USERNAME=FRANK then go write some records into logging_table' -and that's a table you create yourself. But that again requires 8i or above.

And we still don't have a way of auditing precisely what Frank has *selected*. Except that in 9i, there is a feature called 'fine grained auditing' that will allow you to do even that. Details (and a demo) available in my 9i New Features document at the website mentioned below, under the 'books' link.

You'll see that what solutions are available to any problem depends very much on the version you are using. *Please* get into the habit of quoting your version in any future post... it makes life so much easier for everyone!

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Helena" <hmatijaca_at_yahoo.ca> wrote in message
news:c5a36d06.0203041046.5f4b4b71_at_posting.google.com...


> I need to set up a audit trail in one user in oracle database, I need

> to see what ever this user is doing, like whenever is looged in etc,

> everything that this person is going to do... can someone please help

> me with this one

>

> Thanks

> Helena