We are using DBA security on our tables here. I have a few power users who will be able to use Developer Studio to write their own reports. How would I disable the SQL PASSTHRU so they can't bypass the DBA security? We don't use the SQL PASSTHRU on any of our reports, so disabling it globally would be ok.

Thanks.

This message has been edited. Last edited by: Mike in DeLand,

Put this as the last line in edasprof.prf, your server profile. This will stop SQL PASSTHROUGH for everyone:

SET DPT=OFF

Thanks!

Hi,

Can we set SET DPT=OFF in a procedure and that will affect only that procedure ?

Thanks in advance
Pierre