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

Norman Dunbar wrote:
>
> Morning Pete,
>
> >> How are you?,
> I'm fine thanks. Still here (temporarily) !
>
> >> 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.
> I have no idea, but the customer is a bank and *nothing* ever gets done
> without going through about 6 weeks of form filling etc etc. It is a
> major PITA - we have the same problems when we try to debug problems
> they have with our app - we cannot get trace files etc. It's even worse,
> they do not have this setup on their test system, but I have requested
> that they do it for me !
>
> >> 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?
> This won't be allowed - too much confidential information.
>
> >> Is it possible to set trace on your 4GL app and see what was sent to
> the database?
> Yes, but see above. I'm totally working blind on this one I'm afraid !
>
> >> .. 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.
> It is possible to trace what is happening on the client and even to see
> if the system is using packages or not - but they won't turn it on on
> the live system for 'confidentiality' reasons (and business rules!) so I
> need to get them to set it up on their test system.
>
> I'm personally 100% sure that they are not using packages (even though a
> Public Synonym for the package exists) and that the app is using the
> batch user's table via plain old vanilla SQL. They say no, but have yet
> been unable to prove it to me. Once I get the test system up and
> running, we shall (hopefully) see. I've shown them my tests which prove
> that it cannot be as they describe :o)
>
> Thanks Pete.
>
> Cheers,
> Norm.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------

If you haven't got trace you can do the old hack of trying to catch db file reads via v$session_Wait and glean which table is being read from the p1/p2 data.

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"