On Mon, Jan 05, 2004 at 11:32:42 +0500, Michael Gill <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
