Configuring ExternalFileAccess with Restrict in v.2.5.4 SS on Win7 doesn't seem to work properly. Full does work; None (the default) works. Restrict seems not to work as documented in firebird.conf.
RECREATE TABLE EXT_LOG EXTERNAL FILE 'h:\externalfiles\test1.txt' ( STAMP CHAR(24), MESSAGE CHAR(100)} ExternalFileAccess = Restrict 'H:\externalfiles'; (tried it with and without the semicolon) (server restarted) But this happens: SQL> insert into ext_log values (CAST (timestamp 'now' as VARCHAR(24)), 'This is just a friendly message to remind you that CON> Christmas Day will be on December 25 this year!'); Statement failed, SQLSTATE = 28000 Access to external file "H:\EXTERNALFILES\TEST1.TXT" is denied by server administrator Same story everywhere I try to locate the \externalfiles\ folder, *except* -- ExternalFileAccess = Restrict 'externalfiles'; RECREATE TABLE EXT_LOG EXTERNAL FILE 'c:\Programs64\Firebird_2_5\test1.txt' ( STAMP CHAR(24), MESSAGE CHAR(100)} Then, and only then, it works. So - did we tighten this restriction? or has something gone pear-shaped? Helen ------------------------------------------------------------------------------ Full-scale, agent-less Infrastructure Monitoring from a single dashboard Integrate with 40+ ManageEngine ITSM Solutions for complete visibility Physical-Virtual-Cloud Infrastructure monitoring from one console Real user monitoring with APM Insights and performance trend reports Learn More http://pubads.g.doubleclick.net/gampad/clk?id=247754911&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
