I have a query that worked in old version of firebird but now creates an error of "password required" even under SYSDBA login. It appears to be the stored procedure Op_Schedule in the join component of the query.
I am able to execute the stored proc in a from query,
i.e. select * from Op_Schedule(xx,yyy, zzz,wwww)
and I can execute the query below with the proc removed.

Has the standard changed? or am I doing something stupid?

Gds_$compile_request failed
password required
Statement: Select s.site,pt.TaskCode,pt.task,pt.namecode,pt.servicecontactcode, sked.*
From projtask pt
inner join project p on (p.projectCode = pt.projectCode)
left outer join Op_Schedule('t',pt.TaskCode, '2 jun 2002','Next')sked on (1=1)
left outer join name n on n.namecode=pt.namecode
left outer join sites s0 on (s0.sitecode=pt.sitecode)
left outer join sites s on (s.sitefield2=s0.sitefield2)
Where (p.root =11)and (sked.scheduledate is not null)
order by s.site,pt.taskcode,sked.scheduledate;