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,

Marc


-----Ursprüngliche Nachricht-----
Von: Martijn Tonies [mailto:m.tonies@...]
Gesendet: Montag, 22. Dezember 2003 14:13
An: firebird-support@yahoogroups.com
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
Server.
Upscene Productions
http://www.upscene.com



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com





_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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