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 |
Wang
Starting Member
48 Posts |
Posted - 2006-02-21 : 07:42:05
|
HiI have started working with a bunch of developers with a slightly cavalier attitude to security. Now without getting into a long discussion about security(trust me I'm working on it...), is there a way for me to prevent EM connections to a db server? I ask because I feel fear every time someone casually pops open an sp/table/etc in EM on the production servers...I really want to prevent it. Yes I am moving to have em ditched from most machines, but I want to restrict access to the db based on connection type... any way you lot know?Cheers. |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-21 : 07:48:17
|
revoke or deny permissions? go to the database level on this oneif they don't have the permission to be in the database, they can't browseor you can explicitly revoke permissions from public group but this will be a lot of work as each combination may give you different resultsenjoy!--------------------keeping it simple... |
|
|
|
|
|