Q. I've got thousands of files, each of which I want to have different permissions. Customers can buy access to any number of these individual files, and this information is stored in an ODBC database. Do I have to individually protect each file with a different SELECT statement, or is there an alternative.
A. Each file or directory that has different access requirements will need its own protection entry. For lots of files, this can be problematic, impracticable, or impossible.
An alternative is to use the
One of the parameters is the script name (ie requested file),
and you can use this to construct
your ODBC statement according to your own database schema.
Protect the directory containing the files using the "By COM" tab and
refer to the
Make sure you check the
call on every request option.