The user group “administrators” had full access rights before

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » The user group “administrators” had full...

The user group “administrators” had full access rights before

Rate Topic

Display Mode

Topic Options

Author

Message

mschubert

Posted Tuesday, August 26, 2008 1:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, August 06, 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

GilaMonster

Posted Tuesday, August 26, 2008 1:38 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687, Visits: 29,946

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 »

Permissions