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 |
|
imrul
Starting Member
36 Posts |
 Posted - 2013-10-21 : 02:33:50
|
| Is there any way to enforce password in the database attach process?My purpose is to restrict the user to attach database to a server without correct authentication. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-21 : 10:09:01
|
| I don't think there is a way to control attach/detach permissions via passwords. The ability to attach a database requires CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission; and once a login has that permission they can attach.It is an unusual business scenario where end users need to attach and detach databases. Can you describe the business problem that you are trying to solve via this approach? There may be better/more secure alternatives. |
 |
|
|
imrul
Starting Member
36 Posts |
Posted - 2013-10-22 : 02:00:17
|
| You are correct; this is a very unusual problem. The application is desktop base and using SQL 2008 at the backend. Sometimes a user turnoff the SQL service, copy the database files. Then attach the database in a different server, modify data, copy the modified database files back to the server. |
|
|
|
|
|
|
Password in DB attach