Re: Privilege Help
From: Edwin <vanmeerendonk_at_wxs.nl>
Date: 9 Sep 2002 06:45:35 -0700
Message-ID: <31354201.0209090545.17879196_at_posting.google.com>
Date: 9 Sep 2002 06:45:35 -0700
Message-ID: <31354201.0209090545.17879196_at_posting.google.com>
Well, you are allowed to select from the table, but you are not able to see it.
as user EM:
select * from fan;
select * from fan;
By the way
NEVER CREATE OBJECTS AS SYSTEM!!!!!!!!!!!!!
a) select * from system.fan;
or
b) Create a synonym private to em or public for everyone and you can
or
c) alter session set current_schema=SYSTEM; and you can