Re: Auditing...

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