Link to home
Start Free TrialLog in
Avatar of Greens8301
Greens8301

asked on

minimum priv to select across schema

I have sql*net access to schema1 and schema2

If I am in schema1 I cannot run a query that joins table from schema2

What is the minimum priv required for selecting tables from both schema at the same time logging in one of the schema (besides granting a role with 'grant select on ... to ....)

oracle 11.2

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sean Stuber
Sean Stuber

you might also want synonyms
other wise you'll need to prefix the objects with the schema owner

select * from schema2.some_table

if you're looking for a "grant select all in schema"  privilege,

such a privilege doesn't exist
Avatar of Greens8301

ASKER

Thanks