Subject Re: [ib-support] Encoding Procedures in InterBase
Author Ann W. Harrison
At 02:20 PM 2/17/2001 +0000, samersyd@... wrote:
>Hi,
>How can I encode Procedures in Interbase to prevent users from seeing or
>editing the source code?

The easiest thing to do is to delete the source:

update rdb$procedures
set rdb$procedure_source = NULL
where rdb$procedure_name = 'MY_PROC';

After you have deleted the source, you will no longer be able
to recreate the database by extracting the metadata through ISQL,
but backup and restore will continue to work.


Regards,

Ann
www.ibphoenix.com
We have answers.