On Mon, Jan 05, 2004 at 11:32:42 +0500,
Michael Gill <mgill(at)pointdx(dot)com> wrote:
>
> I think I have found the simple solution by separating the user from the
> owner of the tables, however!
>
> I have simply created tables and functions in the owner's schema(A),
> then granted execution to the other user(B). My brief testing indicates
> that B cannot access or describe A's objects, yet can execute the
> function that retrieves data and returns a ref cursor.
>
This won't work as they can still get at the system catalog which will
allow them to see the schema.