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 |
|
scrambled2k3
Starting Member
1 Post |
 Posted - 2008-05-22 : 09:37:38
|
| I have a vendor that needs to remote in to our SQL 2005 Enterprise server and connect to their database. I have created them a username and password in SQL and they can VPN into our network and connect to their database using Management Studio just fine. So far so good! The issue is this: They need to be able to see the processes of an application that connects to their database. When they run 'sp_who2' all they can see is themselves running 'Management Studio'. What else do I need to give them permission to in order for them to see all processes that are tied to their database? I need to do this without giving them permissions to other databases. I have several databases on this server.Thanks in advance! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-22 : 09:50:23
|
| Check View server state Permission to See activity monitor and processes in Books online. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-22 : 22:40:48
|
| They can see all connections once you granted permission, but that doesn't mean they can access other dbs as long as you set db access properly. |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-25 : 12:23:38
|
| As I understand, if you have given proper permission to the vendor. I t doesn't matter if they use VPN or they are in the office location. You also didn't login to the server manually.Anyway, if vendor has proper permission then probablly he/she should be able to see all processes and other info as well from SP_WHO2 command.One more small hint. Please check with the vendor that he/she use that particular DB on the server.I mean Connect to the server <Server> Go to SQL QA andUSE <DBNAME>GOSP_WHO2ManojMCP, MCTS |
|
|
|
|
|
|
Permissions