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.
003 5:29 PM
>>>To: Multiple recipients of list ORACLE-L
>>>Subject: Referencing other schemas' tables in PL/SQL procedure
>>>
>>>
>>>Hi,
>>>
>>>one of our developers is having a problem. His userid has
>>>the DBA role on a
Hi,
one of our developers is having a problem. His userid has the DBA role on a test
database, and he's written a PL/SQL procedure, in his schema, which is referencing
(via SELECT) and updating a table in another schema, so he's coding the select as:
CURSOR c1
IS
select distinct ORIG
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
(B-Ursprungliche Nachricht-
Von: Naveen Nahata [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 12. August 2003 14:34
An: Multiple recipients of list ORACLE-L
Betreff: RE: Referencing other schemas' tables in PL/SQL procedure
There was a discussion on this list, regarding t
Paul Vincent [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, August 12, 2003 5:29 PM
>>>To: Multiple recipients of list ORACLE-L
>>>Subject: Referencing other schemas' tables in PL/SQL procedure
>>>
>>>
>>>Hi,
>>>
>>>one of our deve
