Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The user group “administrators” had full access rights before Expand / Collapse
Author
Message
Posted Tuesday, August 26, 2008 1:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 6, 2012 7:54 AM
Points: 1, Visits: 31
Our sql server 2005 with sp1 has a strange behaviour. We had executed the following sql query:

EXEC sp_attach_db ‘OurDB’,’d:\Databases\Test.mdf’,’d:\Databases\Test_log.ldf’

EXEC sp_detach_db ‘OurDB’

in the Microsoft SQL Server Management Studio. After this the access rights of the Test.mdf and Test_log.ldf files were changed.

Before the execution the user group “administrators” had full access rights to these files but after the execution the user group “administrators” disappeared from the access control list.

Has anybody else experienced such a behaviour or maybe is this a known bug of the sql server 2005?

Thanks!
Post #558647
Posted Tuesday, August 26, 2008 1:38 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:21 PM
Points: 42,495, Visits: 35,566
I've seen it a couple times, but I have no idea what causes it. It doesn't happen every time a database is detached.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #558658
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse