Hi Rod,

> Can you encrypt stored procedures ?

You mean the stored procedure's source (DDL)?

Not via the engine, but if you want to hide the source
from third-party eyes, then for example you can delete
the source or whatever you want to do with it, because
PSQL code modules are compiled into an internal language
called "BLR", and for executing the PSQL code module the
compiled version is taken.

Though, be sure that you have the source in a safe place,
just for the case that you want to recompile the SP at
a later point.


Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com