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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-24 : 08:28:40
|
| John writes "Is there a way in which a user can be granted database access but prevented from accessing the database through Enterprise Manager?Thanks,John" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-24 : 08:28:58
|
| Don't install Enterprise Manager on the user's computer. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-24 : 12:02:14
|
quote:
Originally posted by robvolk
Don't install Enterprise Manager on the user's computer.
Sharp as a tack!Brett8-) |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-27 : 13:50:07
|
| OK, I understand the desire to not let people use Enterprise Manager. Heck, I even blogged on the topic ([url]http://weblogs.sqlteam.com/markc/posts/343.aspx[/url]). But what is your real concern? If you have setup your security (logins & permissions) properly, there should be no concern if they use Enterprise Manager because they are still restricted in what they can accomplish. Enterprise Manager does not automatically give you sysadmin privileges. It is still based on the login.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
|
|
|
preventing access to Enterprise Manager