are the ALL_* views usually viewable by all users?

From: <>
Date: Mon, 02 Jun 2008 17:41:54 GMT
Message-ID: <ChW0k.4263$>

I'm currently querying the USER_* views to do introspection on a user's schema. But, in order to handle aliases, I need to use DBMS_UTILITY.NAME_RESOLVE and the ALL_* views.

Will I enounter any unexpected issues where a random user won't be able to execute DBMS_UTILITY.NAME_RESOLVE or access the ALL_* views?

If so, what's the role they should have to access these? Will that be a common case?

Many TIA,

Mark Harrison
Pixar Animation Studios
Received on Mon Jun 02 2008 - 12:41:54 CDT

Original text of this message