Is there such a thing as a PL/SQL context in Oracle?

Here's an odd question that has bugged me for a while. Say I create a table named fruit in schema guest. Then I also create a function named GetFruit in schema guest that simply queries table fruit and returns something. Now, I want to allow the function GetFruit to query table fruit, but not permit a direct query on the table itself. How do I, or can I even, instruct Oracle to discriminate based on the type of caller?

Something like revoking SELECT on the table but granting SELECT BY PROCEDURE simulataneously.

Thanks! Received on Wed Sep 15 1999 - 07:41:29 CDT