I created a trigger to update changes in a column and it works fine when I
execute in Query Analyzer,
But when user update data thru third party application, the trigger fail to
fire. Is there a permission issue relate to trigger. If I drop the trigger,
the user can update data.

Thanks,
Culam

Does trigger read or write from any other tables besides the one the update
is on?
Are you logged on to Query Analyzer using same credentials as third party
app logs on with?

"culam" wrote:

It just do an update if data change.

I used different credientials in QA, How do I set permission to Triggers
Culam

"CBretana" wrote:

It's not permissions on Trigger, trigger is called by Server from same
spid/logon credentials that original update was called from.

But if Trigger is trying to do something that 3rd party app is not
authorized to do, like update some other table that 3rd party app does not
have update permissions on, then entire transaction may fail. So try to
create a connection in query analyzer using same logon credentials thjat 3rd
party app is using, then see if problem can be reproduced...
It might work ok from Query Analyzer now because you're logged on there with
more rights than 3rd party app has...


"culam" wrote: