| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Packages, tables, inbvoker and definer - wierd problem !
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.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com -------------------------------------Received on Fri Aug 01 2003 - 04:06:39 CDT
 |
 |