Changed file permissions after detach

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin9876 - 10 Jul 2008 16:12 GMT

On a SQL 2005 SP2 when detaching a user database as a user (has admin
rights) using management studio from another pc. Afterwards the
permissions on the database files only have permissions for the user
that was used for the detach.

Is this a known issue of it resetting the file permissions?

Reply to this Message

Gail Erickson [MS] - 10 Jul 2008 16:30 GMT

> Is this a known issue of it resetting the file permissions?

This behavior is by design and is new security enhancement introduced in SQL
Server 2005. See this Books Online topic for the details:
http://msdn.microsoft.com/en-us/library/ms189128.aspx

Signature

Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx

> On a SQL 2005 SP2 when detaching a user database as a user (has admin
> rights) using management studio from another pc. Afterwards the
> permissions on the database files only have permissions for the user
> that was used for the detach.
>
> Is this a known issue of it resetting the file permissions?

Reply to this Message