Don't take it too hard. Acknowledge the error and move on. We all put a foot in the mouth once in a while...J -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx> www.proquest.com <http://www.proquest.com> www.csa.com <http://www.csa.com> ProQuest...Start here. From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of kinzlaw cgm Sent: Friday, August 10, 2007 7:03 AM To: Michael Garfield Sørensen Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Unexpected result from ALL_TABLES Hi Michael! Sorry and yes, the one who needs to read the Docs is me. As I have said, I'm quite new to Oracle. I just happened to read some stuff on ALL_TABLES and USER_TABLES(and other things about ALL_* and USER_* views), but I have memorized it exactly. When seeing Dennis' situation, in my opinion I "figured out" that ALL_* views is about all the things on the system "with confident" and haven't given a try. After reading your mail, I experimented with a simple case, which told me that ALL_TABLES are the tables with which the user has access to. I apologize for negligence of mine and saying wrong thing on the list. -- Learning Oracle http://kinzlaw.wordpress.com