are the ALL_* views usually viewable by all users?
Date: Mon, 02 Jun 2008 17:41:54 GMT
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?
-- Mark Harrison Pixar Animation StudiosReceived on Mon Jun 02 2008 - 12:41:54 CDT