Default NTFS security for new DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sting7777 - 29 Jan 2007 19:12 GMT

We have loaded the hotfix that takes care of NTFS permissions being
reset when detaching and attaching a DB - but when a user creates a
New DB - the NTFS file permissions get reset and are not the
permissions that we want to be set as default. The permissions we
want are those assigned to the folder which the new DB is created in -
I would like the permissions to be inherited if possible - not reset
to what 2005 "thinks" they should be.

What am I missing here?

Reply to this Message

Mark J. McGinty - 29 Jan 2007 20:10 GMT

> We have loaded the hotfix that takes care of NTFS permissions being
> reset when detaching and attaching a DB - but when a user creates a
[quoted text clipped - 5 lines]
>
> What am I missing here?

Try setting them on the model db files. (model is used to determine a
number of details when creating new dbs.)

-Mark

Reply to this Message