Different results from all_objects
Can someone please explain me,
How it is possible to get different results from "all_objects", once I query it from "SQL Worksheet" and next time when I execute the procedure with the same query ?
The procedure is created by schema user (owner) and it's executed by it.
Same as the query.
I am querying for objects which belongs to other owners.
Is there a way how to trace which privileges are used for querying the "all_objects" ?
Any hint will be very welcomed ?