Hello;

Your current user needs access to these views.

GRANT SELECT ON :Object: to CurrentUser;
OR
GRANT SELECT ANY TABLE TO ...

With 9i you need additionally a grant for viewing catalog objects;
GRANT SELECT CATALOG -- ore something like this, view the doc please

Orca