Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!m73g2000cwd.googlegroups.com!not-for-mail
From: javier.ayuso@gmail.com
Newsgroups: comp.databases.oracle.misc
Subject: schema privileges
Date: 8 Aug 2006 00:42:36 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <1155022956.320890.229850@m73g2000cwd.googlegroups.com>
NNTP-Posting-Host: 213.229.157.93
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155022963 7115 127.0.0.1 (8 Aug 2006 07:42:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Aug 2006 07:42:43 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060604 Firefox/1.5.0.4 Flock/0.7.0.15,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: m73g2000cwd.googlegroups.com; posting-host=213.229.157.93;
   posting-account=hblFTQ0AAACnO3l6RSbhdrogD--HA14p
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:129127


Hi,

I need to make queries from one schema to others without having to add
that other schema as prefix in the select order, and I have heared that
I need to grant select privileges to my user on the other schemas,

is this right? and if so, how is it done?

thanks!
Javier