Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
summoner
Starting Member
2 Posts |
 Posted - 2008-10-14 : 06:07:43
|
| Hi,There is a program for a normal user to attach a database file (for operations such as backup). When the data files are attached to the database, the inheritance file permission is lost. [url]http://msdn.microsoft.com/en-us/library/ms189128.aspx[/url]This is due to the behavior of SQL server 2005. However, perserving the inheritance permission is necessary in my system because the user is a normal user and he/she cannot have admin rights.I have read the following post. It said " Add SYSTEM and SERVICE group to have full control in access control list". But it seems it does not work[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=91687[/url]What I want is to perserve the inheritance setting, or perserve the modification right to the users.Thank you very much for your help! |
|
|
|
|
|
Permission are lost after attaching data files