--run this script with SYSTEM user
--replace LAMBERTUSO with your user

drop schema PAL;

--create and set the schema
create schema PAL;
set schema PAL;

--Check if AFl PAL functions are installed
select * from sys.afl_functions where package_name = 'PAL';

--Start the script server
alter system alter configuration ('daemon.ini', 'SYSTEM') set ('scriptserver', 'instances') = '1' with reconfigure;

-- authiorise creation and removal of PAL procedures
grant AFLPM_CREATOR_ERASER_EXECUTE to LAMBERTUSO;

-- Authorise execution of PAL procedures
grant AFL__SYS_AFL_AFLPAL_EXECUTE to LAMBERTUSO;

-- Authorise read access to execute data
grant select on schema PAL to LAMBERTUSO;