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
An: firebird-support@yahoogroups.com
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
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com




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





Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cdbeb8j/M=258297.4271147.5470572.4049140/D=egroupweb/S=1705115386:HM/EXP=1072174829/A=1683962/R=0/*http://www.techsmith.com/rdr/ban/syah/default.asp> click here
<http://us.adserver.yahoo.com/l?M=258297.4271147.5470572.4049140/D=egroupmail/S=:HM/A=1683962/rand=949164943>


_____

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]