further to SEURITY ALERT by SQL MONITOR

I know of only one way to protect senitive information from being listed by the SQL MONITOR (Borland Delphi C/S information/debug too). And that is to pass such information using parameters.

e.g.
instead of writing
SET ROLE secure_role IDENTIFIED BY password

write
SET ROLE secure_role IDENTIFIED BY :parameter and then
query1.paramByName('parameter').AsString := 'password'

Does anyone know of any other way?

Regards,
Nasir (nnoor_at_cris.com) Received on Thu Nov 13 1997 - 00:00:00 CST