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 -> Packages, tables, inbvoker and definer - wierd problem !

Packages, tables, inbvoker and definer - wierd problem !

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 1 Aug 2003 12:32:56 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703FABE32@lnewton.leeds.lfs.co.uk>


Hi Niall,

>> I see no way for what the DBA is telling you to be true. I do see
some ways
>> for what he is describing to be happening.
We agree on this bit !

>> 1. Have you verified that the stored proc really doesn't have AUTHID
>> CURRENT_USER in it. What I mean is does the text of the SP reflect
what your
>> 4GL would produce or has it been massaged b a DBA on site at some
previous
>> time. select text from user_source where ... order by line;
I have already checked the source code for the package extracted from user_source line by line. It is not specifying AUTHID anywhere - as I suspected. When I saw this, I became even more suspicious of what the DBA was telling me (via a consultant - which adds to the confusion !).

>> 2. Have you checked for the existence of yet another object with the
same
>> name, IE a procedure owned by batch?

There is only a public synonym 'in' the batch user with the same name as the package - nothing else.

I think we all agree that the DBA is fibbing when he says that packages are being used - they cannot be given the circumstances and what has been discovered. Getting further info is like getting a refund from the tax man (or getting England's cricketers to a winning position !) but I still have to support them.

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
-------------------------------------
Received on Fri Aug 01 2003 - 06:32:56 CDT

Original text of this message

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