package body text for other users

[jmodic]

What Oracle version?

I've just tried it on my 8.1.7 and I can see the source of package bodies of other schemas that has been granted execute to me from ALL_SOURCE.

SELECT * FROM all_source WHERE type = 'PACKAGE BODY' AND owner = 'SOMEOTHERSCHEMA";

[Edited by jmodic on 07-09-2001 at 10:11 AM]