Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

permissions for stored procedure on remote server

Status
Not open for further replies.

grouping

Programmer
Apr 24, 2001
4
US
hi sql gurus,

my company has a client-server app which updates certain tables in a sql 6.5db. on one of these tables i have an insert trigger which calls a local stored procedure. This local stored procedure then calls a remote server stored procedure. i have defined a specific login for the remote server.

The problem is when a new row is inserted into the table
through the application(the trigger->stored procedure is executed with the permissions of the person who is logged
into the application) and not the remote server login that i defined on the sql server.

Is there a way to hard code the username which i would like to use to execute a stored procedure.

thanks for your help..
Nikhil..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top