Subject AW: [firebird-support] Re: Encrypting stored procedures
Author Marc Geldon
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.

Best wishes,

Marc Geldon

-----Urspr√ľngliche Nachricht-----
Von: Thomas Steinmaurer [mailto:ts@...]
Gesendet: Montag, 22. Dezember 2003 11:20
Betreff: RE: [firebird-support] Re: Encrypting stored procedures

> This sounds like what I need but how do I do that?
> If I view my stored proc source via IBConsole - this is what I want
> to remove but of course leaving the compiled code intact.
> What must I do ?

update rdb$procedures
set rdb$procedure_source = null
where rdb$procedure_name = 'MYPROCEDURE';

Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
Logging/Auditing Suite for Advantage Database Server

To unsubscribe from this group, send an email to:

Yahoo! Groups Sponsor

<*> click here


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]