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 |
|
freshman
Starting Member
2 Posts |
 Posted - 2004-05-14 : 09:44:40
|
| Hope someone can help with this....I have a Proc I want to call from a scheduled Job. So far no problem.The Agent account is set up as Local and the Proc calls another Proc on a linked Server. Is there a way in T_sql to provide the 'Account to use' when Executing the Proc?Eg EXEC @RC = MyDB..MyProc AS User, PasswordOr am I stuck with changing the permissions the Agent account has.... |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-05-14 : 11:01:11
|
| No. This feature is not present in SQL2K.------------------------I think, therefore I am |
 |
|
|
jharwood
Starting Member
41 Posts |
Posted - 2004-05-14 : 11:41:33
|
| Can you use the remote login security option on the linked server or do other processes use the link? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-14 : 13:43:24
|
| Yes you'll need to use the remote login option in the linked server. But if you do that, be aware that all users that access that linked server will now have those permissions too. This is why jharwood asked if other processes use the link. So if you specify sa account (just as an example), then other users will have sa on the remote server over the link.Tara |
|
|
|
freshman
Starting Member
2 Posts |
Posted - 2004-05-17 : 04:07:27
|
| OK. Thanks all. Will give it a try. |
|
|
|
|
|
|
Calling Proc from Job - permissions