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 |
|
marka971
Starting Member
2 Posts |
 Posted - 2006-02-10 : 03:45:42
|
| Hi,Is it possible to run a SELECT in SQL Server as another user (provisind uid and pwd) than the one you are logged in as? BRMarkus |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-10 : 03:58:01
|
| what's provisind?if you mean different nt login id, then yesor you mean after logging into sql server? then no--------------------keeping it simple... |
 |
|
|
marka971
Starting Member
2 Posts |
Posted - 2006-02-10 : 05:02:45
|
| sorry, provisind = providingfor example, i am logged in to sql server in query analyzer as user A, and i want to run a SELECT as user B, is that possible?thanks markus |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-12 : 22:34:48
|
like changing database connection? no, i don't think so...when you're connected, you're connected as the user who establishes the connection (this sounds like Kristen's Test thread  ) unless you disconnect from that connection or open another connection in a separate QA instance--------------------keeping it simple... |
|
|
|
|
|
|
SELECT using a different user