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 |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2006-04-19 : 10:08:19
|
| I installed SQL Server Developer Edition on Windows 2003 server for our sales force. I don't want them to have acces to enterprise Manager and Query Analyser.How to disable these?ThxVenu |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-19 : 11:17:28
|
| Did u install them the 2 of those to Sales, if not how they r going to use those?Or in ur organization computers are shared ? (I mean same computer being used by several ppl)Srinika |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2006-04-19 : 11:49:31
|
| They are not going to use the EM and SQL Analyser.There is an Application which connects to the SQL Server locally |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-19 : 12:00:01
|
| If u do not install EM & QA in Sales Dept PCs, the problem doesn't ariseSrinika |
|
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-04-19 : 14:16:14
|
| I'm guessing you don't want to have access to the data in a direct manner. However, keeping EM and QA out of their hands won't resolve the issue. If they know how to do something in EM or QA they could just as easily do it in Access, or a million freeware query tools. Right? Just something to think about (dread) and keep you up at night.Dalton |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-19 : 20:55:39
|
| restrict their permissions (you have no control over external variables outside your job description)... i find restricting the public role does the trick but it might not be your caseexperiment a bit with revoking, denying permissions--------------------keeping it simple... |
|
|
|
|
|
|
Enterprise Manager