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..
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..