Hi All,

We found a problem when using a UDF that receives the value of a
subselect from a view. Firebird does parse the access right correctly
and says that there is no permission for read/select on the
underlaying table.

Ex:
/* Make sure there is a user "test" in firebird.*/

create database "c:\test.fdb" user "sysdba" password "masterkey";
create table test(test integer);
create view test_view
as
select *
from test;
grant all on test to view test_view;
grant all on test_view to public;
commit;
insert into test values (1);
commit;
select abs((select sum(test) from test_view)) from test_view;
/*The select statement was succesfull*/
commit;
connect c:\test.fdb user "test" password "password";
select * from test_view;
DECLARE EXTERNAL FUNCTION ABS
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';
commit;
select abs((select sum(test) from test_view)) from test_view;
/*last statement raises an exception:
Statement failed, SQLCODE = -551

no permission for read/select access to COLUMN TEST*/
quit;

Does anyone know about this problem?
The above script was written for isql.exe.

WI-V6.3.4.4910 Firebird 1.5
Windows XP SP2.

Cheers,
Calin.