Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing...

Re: Auditing...

From: Maxim V. Krapivin <baltros_at_mail.wplus.net>
Date: Wed, 22 Apr 1998 16:42:30 +0400
Message-ID: <353de5aa.0@nam>


Jimmy wrote :

> Is it possible to record who access table A in Oracle server? The
>access include select, update, delete and insert. I know that Oracle
>server can do audit in table level. Is it possible to audit in record
>level? i.e. to record which record in table A has been accessed?

Oracle server can't do audit in record level. But you can organize you own audit scheme using database triggers, stored procedures and packages.

For example, you can store user name in variable within package. The instance of a package body will be created for every database session. Define triggers for required tables (triggers may be before insert, before update, etc.) which checks value of package variable during record processing. Your triggers may decide can user in current session to do specified processing or not.

Maxim. maximka_kr_at_usa.net Received on Wed Apr 22 1998 - 07:42:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US