Subject AW: [firebird-support] Re: Encrypting stored procedures
Author Marc Geldon
And what about different releases? Maybe I do that with a firebird release but the user has a older / newer one?

Thank you very very much in advance for your response!

Best wishes,


-----Urspr√ľngliche Nachricht-----
Von: Martijn Tonies [mailto:m.tonies@...]
Gesendet: Montag, 22. Dezember 2003 14:13
Betreff: Re: [firebird-support] Re: Encrypting stored procedures

Hi Marc,

> Is there a function (maybe in the gds32.dll) to compile the source code
from the stored procedure. For example: if I give the user the opportunity
to create a new database in my application with my stored procedures.
Normally I have to create the procedures and remove the source code with the
update-SQL. But if someone logs the SQL statements, network traffic or
whatever, everybody can see the source.
> Is there another way?
> Compile it on my machine and insert the compiled code? But what about
different releases? Will that work? Or .... as I asked: is there a function
or something like that in a DLL?
> Thank you very much in advance for your response.

If you want your users to create a new DB, why not restore
a meta-data only backup into a new db? This way, you can
have your procedure code erased, create a backup, and restore
that backup.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions

To unsubscribe from this group, send an email to:


Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to: <>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <> .

[Non-text portions of this message have been removed]