Re: Missing Grant on Package Body

Ok, I found where it is coming from. It is the function qcsdump942. It didn't produce any output in my case because I used an existing table for which a user has no privileges.
Once I started using a table that does not exist at all, I started getting those messages per OERR: ORA-942 "table or view does not exist" Reference Note (Doc ID 18536.1)
I assume that you are using a non-existent table rather than an existing one.

*-- NO OUTPUT IN THE TRACE FILE WHEN AN EXISTING TABLE IS USED* SQL> select * from tc_table.t_select;
select * from tc_table.t_select

                       *

                       *

> It can be seen from the output I provided previously that I searched for
> the word signal too.
>
>> egrep -iw 'signal|tc_table'
>> /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc
>
>
> The `-w` flag was used because there were multiple "ERROR SIGNALLED" lines
> such as one below:
>
>> CALL TYPE: call ERROR SIGNALED: no COMPONENT: PLSQL_Infrastructure
>>
> Even after removing the `-w` flag or using the exact command you were
> using I am not getting any hits on 19.23 with my specific test case.
> Which means that there are no such lines in my environment.
>
> [oracle_at_myhostname ~]$ egrep -i 'signal'
> /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc | grep -i
> about
> [oracle_at_myhostname ~]$ egrep -nT -A+1 "about to signal"
> /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc
> [oracle_at_myhostname ~]$
>
> On Thu, 11 Jul 2024 at 14:47, Jonathan Lewis <jlewisoracle_at_gmail.com>
> wrote:
>
>>
>> The "Name" is restricted to the name of the table and doesn't include the
>> schema, and I think tc_table is your schema.
>> I should have said I was using 19.11; and my choice on egrep was
>>
>> egrep -nT -A+1 "about to signal" or19_ora_23101_level1.trc
>> 5154 :about to signal 942
>> 5155 -Name: FAIL1
>>
>> It would be necessary to search the rest of the file for the object name
>> to find the SQL, and that might be messy given the way the text would be
>> arbitrarily cut into 16 byte pieces.
>>
>>
>> Regards
>> Jonathan Lewis
>>
>>
>>
>> On Thu, 11 Jul 2024 at 13:51, Mikhail Velikikh <mvelikikh_at_gmail.com>
>> wrote:
>>
>>> there are no such lines in 19.23 for my sample test case using the
>>> default DB parameters.
>>> alert log:
>>> 2024-07-11T12:46:05.314540+00:00
>>> PDB(3):Errors in file
>>> /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc:
>>> ORA-00942: table or view does not exist
>>>
>>> egrep -iw 'signal|tc_table'
>>> /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc
>>> 7F6E37B25750 4F524620 4354204D 4241545F 542E454C [ FROM TC_TABLE.T]
>>> 7F6E37FBEE40 4F524620 4354204D 4241545F 542E454C [ FROM TC_TABLE.T]
>>>
>>> Best regards,
>>> *Mikhail Velikikh*
>>>
>>>
>>>
>>> On Thu, 11 Jul 2024 at 13:44, Jonathan Lewis <jlewisoracle_at_gmail.com>
>>> wrote:
>>>
>>>>
>>>> This may be version-dependent and feature/parameter dependent, but even
>>>> dumping an errorstack (on 942) at level 1 I found the following pair of
>>>> consecutive lines in my trace file:
>>>>
>>>> about to signal 942
>>>> Name: XXXXX
>>>>
>>>> (where xxxxx was the name of the missing / unavailable object)
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Regards
>>>> Jonathan Lewis
>>>>
>>>>
>>>>
>>>> On Thu, 11 Jul 2024 at 13:01, Mikhail Velikikh <mvelikikh_at_gmail.com>
>>>> wrote:
>>>>
>>>>
>>>>> If you want to pinpoint the exact object(s) causing ORA-942, then you
>>>>> can use the errorstack event as Mladen mentioned.
>>>>> Level 2 would be enough to dump the necessary library cache structures:
>>>>> alter session set events '942 errorstack(2)';
>>>>>
>>>>>
>>>>>>

--
http://www.freelists.org/webpage/oracle-l