What privileges do you need to access sys.$ tables?...

Oracle db view/system table to check if given part of a package is a Procedure or a Function...