File permissions

Hello,

SQL 2005 resets the file permissions for database files when they are attached. Documentation shows that this is for security purposes. Is there any way to turn off/override this feature? Basically, I need a way to attach a database file while preserving the user permissions with that file.

Thanks.

Just a follow up, but I have not found a way to override the reset of file permissions, so I will try to find another way around the problem.|||

Unfortunately, as far as I know, there is no way to turn off the automatic ACLing of the DB files. As you mentioned, I would also recommend to use an external application or probably a CLR module that can be run from SQL Server to change the ACLs on your files.

I am curious if you considered SQL Express user instances (also known as RANU http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp) as a possible option for your scenario, and if you did we will also appreciate if you can give us some feedback on this new SQL Express-only feature.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine