Re: schema privileges

javier.ayuso_at_gmail.com wrote:
> 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

It is partly right.
You need to grant select (look up 'grant object privileges' in the sql reference manual)
[this will make sure you can select * from scott.emp at all] and
to create a synonym for the affected table (look up 'create synonym' in the same manual)
[ this will make sure you can select * from emp, as if it were your own table}

-- 
Sybrand Bakker
Senior Oracle DBA