Weird thing (access not granted to a table from a procedure

From: Antoine <nospam_at_nospam.net>
Date: Sun, 23 Jun 2002 15:51:41 +0200
Message-ID: <20020623.155140.889023311.11157_at_nospam.net>



Hi,

[Quoted] I have just created a procedure in a package with the system right.

[Quoted] From the system account, i can run sql commands like select * from username.tablename.

[Quoted] But, the procedure body is not compiled 'cause it pretends username.tablename should be declared first (and when i copy and paste the select statement, it runs perfectly, on the same account).

Thx in advance

Antoine Received on Sun Jun 23 2002 - 15:51:41 CEST

Original text of this message