All_Source Question 2007-10-02 - By Neil Overend
Back
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
|
|
