are the ALL_* views usually viewable by all users?
From: <mh_at_pixar.com>
Date: Mon, 02 Jun 2008 17:41:54 GMT
Message-ID: <ChW0k.4263$jI5.3722@flpi148.ffdc.sbc.com>
Date: Mon, 02 Jun 2008 17:41:54 GMT
Message-ID: <ChW0k.4263$jI5.3722@flpi148.ffdc.sbc.com>
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
-- Mark Harrison Pixar Animation StudiosReceived on Mon Jun 02 2008 - 12:41:54 CDT