Re: Need Audit script

What version are you running?

Because if you've got 8i (ie, 8.1.5 or above), I'd recommend getting to grips with Log Miner. Shows you who did what to whom and when. And absolutely no performance overhead, unlike the dodgy Oracle audit system, which you are wise not to want to startup (it never tells you exactly *what* a User has done, and results in an AUD$ table growing at a rate of knots, slows Users down, and -if you forget to move the AUD$ out of SYSTEM tablespace- knackers the key tablespace for the database in a blink of an eye).

Just be aware that tracking down the creation and dropping of tables etc requires you to mine the logs for inserts and deletes on data dictionary tables (for example, UET$, FET$ and -even if using locally managed tablespaces- OBJ$)

Regards
HJR "Feldman Roger" <qrarofe_at_era.ericsson.se> wrote in message news:3AB5D4C0.C9AE1223_at_era.ericsson.se...
> Oracle people:
>
> Could someone give me a hand and show me a script that shows who has
> made changes(new table entries or other changes) to the DB without
> having to startup the whole "audit" system ?
>
> I've tried a script from my not so handy oracle book- doesn't work and
> I've failed to hack it into shape :-(
>
> Here it is:
>
> -----
> col Owner format a20
> col Object_Name format a30
> col Timestamp format a20
> select Owner, Object_Name, Object_Type, Status, Timestamp
> from DBA_OBJECTS
> where SUBSTR(Timestamp,1,10) = TO_CHAR(sysdate-1,'YYYY-MM-DD')
> order by Owner, Object_Name
> /
>
> ------
>
> Thanks !
>
> Roger
>
>
Received on Mon Mar 19 2001 - 05:07:51 CST