Re: Recognize Data Base Manipulation
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 14 Aug 2002 13:22:43 +0100
Message-ID: <3d5a4b94$0$8507$ed9e5944_at_reading.news.pipex.net>
Date: Wed, 14 Aug 2002 13:22:43 +0100
Message-ID: <3d5a4b94$0$8507$ed9e5944_at_reading.news.pipex.net>
[Quoted] I think that what you are looking for is triggers and the DBMS_APPLICATION_INFO supplied package.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Rudolf Golser" <r.golser_at_teamaxess.com> wrote in message news:3d5a4045_at_e-post.inode.at...Received on Wed Aug 14 2002 - 14:22:43 CEST
> Does anybody know some mechanisms/algorithms for recognizing changes
> to specific data sets in a data base (insert, deletion, change of a data
> set).
> The method should work independent of the integrated password security
> mechanisms in the data base. The method should not prevent changing the
> data, but should recognize that data was changed not by the specific
> security application (hardware/software encryption). Thus, even if a data
> base administrator has Admin rights, it should be possible to recognize
that
> the content was changed directly and not via the service application.
>
> Thank You
>
>