Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
pdkaman

Senior Member
Registered:
Posts: 71
Reply with quote  #1 
We are a growing BPM shop.  We have 6 people with the potential to publish... all sharing the same SQL account (against my preferences) but that is how our DBA group makes it.

So I had the bright idea to create a trigger on the eProcedure table that would raise a flag in a corresponding procedure that could then do a little homework and notify a few of us Senior guys when changes are made.  This would be most useful in UAT where we want some control but ultimately would be run in Production too... as a precaution.

I do not see any risk in this scenario but a more cautious developer doesn't want to use a trigger on a production table.

Any thoughts?  Concerns? Cautions?

Cheers,
Paul
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
I am almost certain it has been tried, and it fails. The designer hangs, waiting for the transaction to complete, but it never does.
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
pdkaman

Senior Member
Registered:
Posts: 71
Reply with quote  #3 
Thanks Jerome.  I'll just roll back if it looks to be a problem then.  Thanks for the info.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!