java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CTE in statement [WITH RECURSIVE CTE(ID, FIRSTNAME, LASTNAME, MIDDLENAME, POSITION, MANAGER, HIREDATE, SALARY, DEPARTMENT) AS
(
    SELECT ID, FIRSTNAME, LASTNAME, MIDDLENAME, POSITION, MANAGER, HIREDATE, SALARY, DEPARTMENT
    FROM EMPLOYEE e
    WHERE e.ID = ? 
    UNION ALL
    SELECT e.ID, e.FIRSTNAME, e.LASTNAME, e.MIDDLENAME, e.POSITION, e.MANAGER, e.HIREDATE, e.SALARY, e.DEPARTMENT
    FROM EMPLOYEE e
        JOIN CTE r ON r.MANAGER = e.ID AND r.HIREDARE < e.HIREDATE
        ORDER BY HIREDATE DESC
)
SELECT ID, FIRSTNAME, LASTNAME, MIDDLENAME, POSITION, MANAGER, HIREDATE, SALARY, DEPARTMENT FROM CTE]