Is there such a thing as a PL/SQL context in Oracle?
From: Martin Douglas <Martin.Douglas_at_Boeing.com>
Date: Wed, 15 Sep 1999 12:41:29 GMT
Message-ID: <37DF93F9.64496ADD_at_Boeing.com>
[Quoted] 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?
Date: Wed, 15 Sep 1999 12:41:29 GMT
Message-ID: <37DF93F9.64496ADD_at_Boeing.com>
[Quoted] 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 - 14:41:29 CEST