Re: Missing Grant on Package Body
From: Alan Sterger <asterger_at_earthlink.net>
Date: Fri, 12 Jul 2024 14:38:07 -0400
Message-ID: <83e7e63d-f89b-4e8f-ba9c-83364a8125cf_at_earthlink.net>
So far, 'alter session set events '942 trace name context forever, level 1'; returns the name of the offended package body, not the missing dependency (on 19.3). And yes, checked for any identically named table or view.
Date: Fri, 12 Jul 2024 14:38:07 -0400
Message-ID: <83e7e63d-f89b-4e8f-ba9c-83364a8125cf_at_earthlink.net>
So far, 'alter session set events '942 trace name context forever, level 1'; returns the name of the offended package body, not the missing dependency (on 19.3). And yes, checked for any identically named table or view.
While I know the package and body OBJECT_IDs, I've been reluctant to wade through the errorstack output for dependency. Do I need a number-hex calculator?
'19.3' is mandated by Oracle for this app. Speaking of which, have a new SR analyst (database) vs the SR application guy.
Received on Fri Jul 12 2024 - 20:38:07 CEST