Subject Re: [firebird-support] Re: FireBird security, where ?
Author Helen Borrie
At 05:47 AM 15/12/2004 +0000, you wrote:


> > delete your metadata before deploying your database. You should deploy
> > your's with compiled BLR. But before you deleting your metadata, you
> > must sure to save your metadata.
>
>how can I delete the meta data?

You can't delete the metadata (I mean, you MUST not!!)

What you can do is delete your procedure and trigger source code.
update rdb$procedures
set rdb$procedure_source = null
where rdb$procedure_name not starting with 'RDB$';

update rdb$triggers
set rdb$triggere_source = null
where rdb$trigger_name not starting with 'RDB$';

But read Geoff's message thoroughly before you decide there's any point.

./hb