Re: SQL 2000 and NTFS

From: Corey Hynes (corey@techsherpas.com)
Date: 10/21/02 

From: "Corey Hynes" <corey@techsherpas.com>
Date: Mon, 21 Oct 2002 16:21:57 -0400

They inherit from the folder in which they are created. If you restrict or
assign permissions at the folder, those will be picked up by the data file.

Corey

"Luis" <hernandez_nJ@hotmail.com> wrote in message
news:8a0a01c27927$866e82b0$2ae2c90a@phx.gbl...
> The default NTFS permissions on the system databases are
> administrator full control and sqlservice (SERVICE
> ACCOUNT) full control. However, for every new database
> that I create the permissions are set for everyone - full
> control. WHy is that so? This does not sound right

Relevant Pages
Quantcast