Title: RE: Referencing other schemas' tables in PL/SQL procedure
story of usual suspects
culprit: SELECT privilege granted through role
Resolution: Grant SELECT privilege as schema owner TO the procedure owner directly.
Any privileges granted through roles are not enabled in PL/SQL procedures.
You need to have the privilege granted directly not through a ROLE.
Regards
Naveen
>>>-Original Message-
>>>From: Paul Vincent [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, August 12, 2003 5:29 PM
>>>To: Multiple re
iginal Message-
>>>From: Paul Vincent [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, August 12, 2003 5:54 PM
>>>To: Multiple recipients of list ORACLE-L
>>>Subject: RE: Referencing other schemas' tables in PL/SQL procedure
>>>
>>>
>>>Naveen
Naveen - many thanks! I had a vague recollection that this may be the case, rattling
around in the back of my mind, but I couldn't find confirmation in the manuals. Thanks
for the definitive answer! It's an annoying restriction, but now we can cope with it!
Paul
-Original Message-
Sent:
