grant debug connect session to isconan;
grant debug any procedure to isconan;
grant debug connect session, debug any procedure to isconan;
grant debug connect session, debug any function to isconan;
grant execute on DBMS_DEBUG_JDWP to isconan;
--GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP TO isconan;

--begin
--   dbms_network_acl_admin.append_host_ace
--   (host=>'WIN-S37KC79C9LL',
--	ace=> sys.xs$ace_type(privilege_list=>sys.XS$NAME_LIST('JDWP') ,
--	principal_name=>'ISCONAN',
--    principal_type=>sys.XS_ACL.PTYPE_DB) );
--  end;
--/
--select host from dba_network_acls;

-- SQL developer =>Tools=>perference=Debug 
-- * Check Prompt debug host
-- * Check Enable Port rang 
-- * Set Firewall/InBound  Access port 4000 - 4999 on Database Server 