Subject Re: protecting SP & trigger code from being viewed
Author Paco Ruiz
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
> Hi,
>
> UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL
>

Can i reverser it at any moment?

Saludos
Paco



> Do the same for triggers.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &
MS SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
> > first of all, please forgive me if this topic has been discussed
before...
> >
> > i made an CS application using FB and before give it to customer,
i would
> like my app(client side) be able to strip all the SP & Trigger
source code
> from the database, leaving only the compiled BLR ( and customer data) .
> > Is is possible to do such thing? , i've searched IB6 doc especially on
> Data Definition Guide with no success.
> > Also reading and digging FB 1.5 RC8 release notes (the first
> commandment/rules to do before posting questions to this group
AFAIK) gives
> me no clue.
> >
> > if the answer is yes, next questions arises:
> >
> > 1. how to do it properly? (other than the hard way: creating those
> objects on app start and drop them on finished - i've not tried this
> myself).
> > 2. those FB utility such as gbak backup-restore etc could it still be
> applicable on that DB?
> > 3. from ethical point of view : is this intention ok ? (
considering that
> FB is an _open_source_ DBMS ).
> >
> > if the answer is no, still i would like to thank you guys
> _developer_&_supporter_ for the nice product you made. ( and nice
support
> you give on this list ).
> >