Re: Packages, tables, inbvoker and definer

From: Pete Finnigan <pete_at_petefinnigan.com>
Date: Thu, 31 Jul 2003 19:05:57 +0100
Message-ID: <6GzCcPBFqVK$EwCJ@peterfinnigan.demon.co.uk>

Hi Norman,

How are you?,

Some thoughts ==>

Is audit turned on?, if not can it be to prove who accesses what?, if so set up audit on the tables and packages. Or.. if the database is in archivelog mode ask for the logs and have a look with Log Miner and see if you can work out which scenario is correct? - Is it possible to set trace on your 4GL app and see what was sent to the database?.. or even set SQL*Net trace to capture the SQL executed, that should show if the 4GL generated package calls or direct SQL as you suspect.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Received on Thu Jul 31 2003 - 13:05:57 CDT

Re: Packages, tables, inbvoker and definer - wierd problem !