Debugger preference "NEVER add debug info for connections..."

[Peter Dequidt]

I tried to disable adding debug information to stored objects for my production databases. I thought the above mentioned preference could make this happen for me, but unfortunately, this doesn't seem to work as I wished:
- What I want to achieve is that on my production database (say: bpro) no-one can add debug information to code.
- What I did to achieve this: I added *@bpro to the above mentioned preference.

This doesn't seem to work: I can still add debug info to whatever object on bpro by right-clicking it and selecting "Add debug information". Does anybody has any experience with this feature?

If this would work, I have another question: how can I specify more than one connection? Should this be a comma-separated or space-separated or ... list? (like *@bpro,*@lpro)

Thanks in advance,

Peter

 

[Marco Kalter]

This preference does not prevent you from explicitly adding debug information. It merely prevents that debug information is implicitly added as a result of a compilation. You will need to use the Authorization feature to enable/disable this function for specific databases, roles, or users.