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 |
|
sboyer
Starting Member
4 Posts |
 Posted - 2007-12-20 : 07:41:21
|
| Hi everybody,I have to create a trigger that will get information from multiple databases with different permissions.In SQLServer2005 I solved this by using the WITH EXECUTE AS ... Dml option. How can I do the same in SQLServer 2000 ? How can I impersonate user ?thxSeb. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 15:58:58
|
| Try with setuser. |
 |
|
|
|
|
|
Trigger permissions