Re: trigger problem

"Connor McDonald" <connor_mcdonald_at_yahoo.com> a écrit dans le message de news:42608243.5AF4_at_yahoo.com...
|
| We adopted a different strategy - when developers log on to our
| development databases we see if you've come through the allowable
| channel (ie, our list of allowable development products).
|
| if not, we submit a job to check through v$open_cursor - most products
| have some "signature" queries that reveal what they are, even if the
| developer has renamed toad etc etc.

Can you say us more about these signatures?

Regards
Michel Cadot

|
| We did this for licensing issues (ie, we are not TOAD licensed but heaps
| of developers had brought in their own hacked versions).
|
| But the same process could be used for the OP's requirement.
| --
| Connor McDonald
| Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
| Co-author: "Oracle Insight - Tales of the OakTable"
|
| web: http://www.oracledba.co.uk
| web: http://www.oaktable.net
| email: connor_mcdonald_at_yahoo.com
|
|
| "GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
| and...he will sit in a boat and drink beer all day"
|
| ------------------------------------------------------------
Received on Sat Apr 16 2005 - 00:23:19 CDT