/*
사용자 함수 목록
OWNER1: 부모
OWNER2: 자식
*/
select
'grant execute on OWNER1.' || ALL_SOURCE.NAME || ' to OWNER2;' as "권한"
, 'create synonym OWNER2' || ALL_SOURCE.NAME || ' for OWNER1.' || ALL_SOURCE.NAME || ';' as "동의어"
, ALL_SOURCE.*
from ALL_SOURCE
where 1 = 1
and owner = 'OWNER1'
and type = 'FUNCTION'
and line = 1
order by
ALL_SOURCE.NAME
;