Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |