From: vanmeerendonk@wxs.nl (Edwin)
Newsgroups: comp.databases.oracle
Subject: Re: Privilege Help
Date: 9 Sep 2002 06:45:35 -0700
Organization: http://groups.google.com/
Lines: 15
Message-ID: <31354201.0209090545.17879196@posting.google.com>
References: <3d790e8d$1_2@spamkiller.newsgroups.com>
NNTP-Posting-Host: 193.67.79.142
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1031579135 26117 127.0.0.1 (9 Sep 2002 13:45:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Sep 2002 13:45:35 GMT


Well, you are allowed to select from the table, but you are not able to see it.
as user EM:
a) select * from system.fan; 
or
b) Create a synonym private to em or public for everyone and you can
   select * from fan;
or
c) alter session set current_schema=SYSTEM; and you can
   select * from fan;

By the way

NEVER CREATE OBJECTS AS SYSTEM!!!!!!!!!!!!!

unless you'r oracle