Hello.
I want to restrict external file access for external tables to one
folder. But I can access external tables only via ...=FULL.
As soon as I restrict it via
ExternalFileAccess = C:\Programme\Firebird\Firebird_2_1\externalFiles
I get the following message:
Access to external file "C:\PROGRAMME\FIREBIRD\FIREBIRD_2_1
\EXTERNALFILES\CONTINGENTS.DAT" is denied by server administrator

The table-creation-ddl:
CREATE TABLE ECONTINGENTS
EXTERNAL FILE 'C:\PROGRAMME\FIREBIRD\FIREBIRD_2_1
\EXTERNALFILES\CONTINGENTS.DAT'
(
DATE_ACTIVE TIMESTAMP,
COV_ID INTEGER,
ZONE_ID INTEGER,
FREE_MINUTES INTEGER,
ACTIVREC SMALLINT
);
Regards, Christoph