Subject Re: protecting SP & trigger code from being viewed
Author Paco Ruiz
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
> ah - no (only while you haven't committed)
> you need to keep a copy of the db with it's source visible
> Alan

but can i update metadata in my customer database like my personal db?
do exist any diferences more between them?



> > > 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 ).
> > > >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >