Privileges Under Oracle 7.1

This is goin to sound like the typical 'newbie' kind of question... But I can assure you that it isnt.

I have an Oracle account with CREATE PROCEDURE and CREATE TRIGGER privileges.. but when I try to compile my procedure I get a PL/SQL error... number 00201 to be exact. Now this error means that an identifier has not been declared.. but the identifier is actually the name of a table owned by another user.

I have checked through SQL*Plus and I have select privileges on the table, and if i change from a stored procedure to an anonymous block structure and run the PL/SQL code through SQL*plus it works.

If I change the procedure to reference a table I have created or a public table such as dual...the code compiles just fine.

So my question is this... what have I missed?

Please ... if you have a solution, I would greatly appreciate ;)

E-mail any suggestions to pixelp_at_ais.net.

Thanx! Received on Fri Dec 15 1995 - 00:00:00 CET