Hi everyone, just some feedback. As Tim said, not a DBISAM problem.

We run table upgrades under elevated privileges (back end services need to be closed down prior to upgrade). As a result the permissions on the files are affected. When running our upgrade from elevated command line, all is fine. However when invoking our UAC via our own manifest, the Authenticated Users and Users groups are removed from the file. Also the owner is affected. Now search for reasons why our manifest file would be causing this.

Kind regards
Danie

Nope, seems Im still wrong.
Please ignore previous post.

Hi noticed this,

4.30 Build 5 Breaking Changes
As of 4.30 Build 5, the TDBISAMSession PrivateDir property now defaults to the local temporary files directory for the current user. Previously, it defaulted to an empty string ('').

I did not set the Private directory for the session and, by the looks of it, the source then assigns the current OS directory.

Now after the above change, the system will default to OSTempDirectory.

My thoughts: when restructuring the table, the tbale is moved back to the data directory after the data has been copied and thus takes along with it the OSTempDirectory permissions. In the past, the permissions would not have been different, whereas now they are.

Assuming I would set the Temp folder to that of my application directory (or temp folder within) and it should retain the permissions (if the folder's permissions are ok).

Any thoughts appreciated.

Danie

Danie,

<< My thoughts: when restructuring the table, the tbale is moved back to the
data directory after the data has been copied and thus takes along with it
the OSTempDirectory permissions. In the past, the permissions would not have
been different, whereas now they are.

Assuming I would set the Temp folder to that of my application directory (or
temp folder within) and it should retain the permissions (if the folder's
permissions are ok). >>

That is the purpose of this property:

http://www.elevatesoft.com/manual?action=viewprop&id=dbisam4&product=delphi&version=7&comp=TDBISAMEngine&prop=CreateTempTablesInDatabase

Tim Young
Elevate Software
www.elevatesoft.com

Thanks again.

Danie