Re: All_Source Question

Create schema1, grant select on dba_source to schema1 (need to do this as sys),
create a view v_source as select * from dba_source where owner in ('A','B' ... etc.)

create schema2 with create session ,
grant select on schema1.v_source to schema2. grant create synonym to schema2
create synonym v_source for schema1.v_source revoke create synonym from schema2

Your users can then log in to schema2 and all they can do is select from v_source.

You could also create several views, one for each schema's source create view v_source1 as select * from dba_source where owner ='A' create view v_source2 as select * from dba_source where owner ='B' with appropriate grants and synonyms. Then it would be easy for users to login and view source from the schema of their choice.

Neil

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