Re: TOAD Access to other Schemas

this is a BIG NO NO. In-fact you can get away with SELECT ANY TABLE, but that too is a NO NO in production/devl environment. Anyone who claims they cannot do any development without these privs is trying for a easy workaround (aka borderline lazy).

Ask them what they want, and grant only that, nothing more. Any blanket privilege (e.g. %ANY% types) are _bad_ imho in development environment because you will need those in production then too.

My $0.0185
Raj

--
http://www.freelists.org/webpage/oracle-l