The user group “administrators” had full access rights before

  • 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!

  • 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, MVP, M.Sc (Comp Sci)
    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply