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 |
|
danielc
Starting Member
49 Posts |
 Posted - 2012-05-04 : 12:32:51
|
| A developer was able to put a database into Single-User mode. After setting the database back to Multi-User mode I looked at his permissions on the database and it was set to read-only. It seems that by default all users can set a database to Single-User mode. How can I limit users from doing this in the future?Thanks,Daniel |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-05-04 : 18:27:16
|
| What do you mean by "I looked at his permissions on the database and it was set to read-only"? Do you mean he has SELECT rights but not UPDATE or DELETE? Is the User a member of either a database or server level Role? I would think that issuing a REVOKE or DENY on the User's ALTER DATABASE rights would prevent any future changes.=================================================There is a foolish corner in the brain of the wisest man. -Aristotle, philosopher (384-322 BCE) |
 |
|
|
|
|
|
Single User Mode