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 |
|
aggletonm
Starting Member
2 Posts |
 Posted - 2008-01-30 : 07:07:26
|
| We have a rather odd requirement to put a 3rd party database on a server in our DMZ (the third party, ourselves and suppliers need access). Is there any way we can give the 3rd party access to Enterprise Manager on that server but only limit them to that one db? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-31 : 03:08:01
|
| Set up a user for them with only access to that DB.Do not give them access to the system databases.If they abuse this at all, remove all permissions for them and sue their arses. |
 |
|
|
aggletonm
Starting Member
2 Posts |
Posted - 2008-01-31 : 04:14:14
|
| Thanks for that - as it happens the 3rd party runs our distribution centres... |
|
|
|
|
|
|
Limiting access to EM