Subject Re: protecting SP & trigger code from being viewed
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
>
> > > UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL
> > >
> >
> > Can i reverser it at any moment?
>
> No. Of course not. Once deleted, you cannot get the source back.

If someone will'nt write own reblrer ;))) Martijn, I have no need
for it in my practice but my sclerosis whishpers something
unintelligible about - NULL or ''? Seems there were problems with NULL
but sclerosis can swindle me ;) And one more his whisper - don't
forget to add Where RDB$TRIGGER_NAME Not Starting 'RDB$' when make the
same with RDB$TRIGGERS table, or some of system triggers will fire
twice.

Best regards,
Alexander.