On the directories where the SQL-Data- (F:\.....\Data) and the Logfiles (G:\....\Log) are stored we set up our own access rights (replace all existing inheritable permissions on all descendants...).
If I create a new Textfile in these directories all is as it should be (ACL is inherited from directory above).
If I create a new db in sql 2008 (default path for Data- and Logfiles pointing to F:\... + G:\... as mentioned above) the db files are created in the correct directories but the ACL of the files is always:
owner rights= full control,
Is there a way to avoid the setting of this "default ACLs" for the Data- + Logfile and let db files take access rights from directory instead ?
Any help is highly appreciated !
View Complete Post