prompt +--------------------------------------------------------+
prompt                                                          
prompt   grant one schema's function excution to another schema 
prompt
prompt   ※주의 : DBA 유저로 로그인하여 실행할것                                                          
prompt +--------------------------------------------------------+

ACCEPT v_sppath prompt "type the spool filename with path[ex : /home/oracle/spool.sql] :"
ACCEPT v_owner prompt "type the grantor username(functions owner) :"
ACCEPT v_pass prompt "type the grantor password(f owner password) :"
ACCEPT v_tns prompt "type the host string(the tnsname) :"
ACCEPT v_grantee prompt "type the grantee username   [ex : scott] :"

set headin off
set verify off
set feedback off
set pagesize 0

spool &v_sppath

select 'GRANT EXECUTE ON '||owner||'.'||object_name ||' TO ' ||UPPER('&v_grantee')||';' from dba_objects where owner=UPPER('&v_owner') and object_type='FUNCTION';

spool off

connect &v_owner/&v_pass@&v_tns
@&v_sppath

set pagesize 1000
set feedback on
set verify on
set heading on

exit