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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Prevent EM connections to DB

Author  Topic 

Wang
Starting Member

48 Posts

Posted - 2006-02-21 : 07:42:05
Hi

I 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 one

if they don't have the permission to be in the database, they can't browse

or you can explicitly revoke permissions from public group but this will be a lot of work as each combination may give you different results

enjoy!

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -