/*

사용자 함수 목록

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

;