grant select to APPS object on different schema without causing invalids in database.

Query to grant select privs on all apps objects to a given schema XYZ without causing invalid objects


select 'exec ad_zd.grant_privs(''SELECT'||''''||','||''''||object_name||''''||','||''''||'XYZ'||''''||')'||';'
from dba_objects where object_type in ('TABLE','VIEW') and owner ='APPS';