Re: How to track structural changes in db
From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 24 Jun 2004 13:18:40 GMT
Message-ID: <QwACc.85695$Hg2.58173_at_attbi_s04>
Date: Thu, 24 Jun 2004 13:18:40 GMT
Message-ID: <QwACc.85695$Hg2.58173_at_attbi_s04>
"LC" <leecholim_at_hotmail.com> wrote in message
news:d15e389.0406240044.65c6e9cd_at_posting.google.com...
> hi,
> i worry about people doing something they shouldn't to my db and I
> would like to track any structural changes (who and which)to my db. I
> am using oracle 8.0.6.0.0 and 9.2.0.2.0.
>
> regards,
> Lee Cho
Best way is to not give them the rights to do any. If you have to then
create a trigger on ddl changes and track the user and when in a table. See
SQL Reference documentation.
Jim
Received on Thu Jun 24 2004 - 15:18:40 CEST