M
Matt Vandermolen
Greetings.
I have 2 Databases with 2 different sets of users, and thus 2 different sets
of permissions. Certain actions on Database A fires a trigger that executes
a stored procedure on database B. If the user in Database A doesn't have
permission on Database B, then the procedure fails, and the User gets an
error. I have been experimenting with the EXECUTE AS function, but it
doesn't seem to work as I had expected. Can anyone give me some tips or
point me in the direction of some holiday reading material? Thanks in
advance.
Matthew Vandermolen
Solutions Architecht
Worktech Inc.
I have 2 Databases with 2 different sets of users, and thus 2 different sets
of permissions. Certain actions on Database A fires a trigger that executes
a stored procedure on database B. If the user in Database A doesn't have
permission on Database B, then the procedure fails, and the User gets an
error. I have been experimenting with the EXECUTE AS function, but it
doesn't seem to work as I had expected. Can anyone give me some tips or
point me in the direction of some holiday reading material? Thanks in
advance.
Matthew Vandermolen
Solutions Architecht
Worktech Inc.