Firebird Documentation IndexFirebird 3.0.2 Release NotesConfiguration Additions and Changes → Parameters Changed or Enhanced
Firebird Home Firebird Home Prev: New ParametersFirebird Documentation IndexUp: Configuration Additions and ChangesNext: Parameters Removed or Deprecated

Parameters Changed or Enhanced

ExternalFileAccess

The following parameters have been changed or enhanced:

ExternalFileAccess

Entries in the “Restrict” list of the ExternalFileAccess parameter can be used to mangle file names with relative paths.

Entries in the “Restrict” list were already used to mangle file names with no path component. For example, with

  ExternalFileAccess = /opt/extern
        

and the following sequence of commands:

SQL> create table qq external file 'zz' (x int);
SQL> insert into qq values(1);
SQL> commit;
        

the file /opt/extern/zz will be created.

But if something like this is submitted,

  create table qq external file 'dir/zz' (x int);
        

the result is an error about denied access to file /opt/firebird/bin/dir/zz.

The improvement avoids this gap by mangling the file name in accord with the value of the parameter and, if necessary, creating the missing path components, such as 'dir' in the example above.

Prev: New ParametersFirebird Documentation IndexUp: Configuration Additions and ChangesNext: Parameters Removed or Deprecated
Firebird Documentation IndexFirebird 3.0.2 Release NotesConfiguration Additions and Changes → Parameters Changed or Enhanced