Subject | Re: [firebird-support] Re: FireBird security, where ? |
---|---|
Author | Helen Borrie |
Post date | 2004-12-15T06:04:48Z |
At 05:47 AM 15/12/2004 +0000, you wrote:
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
> > delete your metadata before deploying your database. You should deployYou can't delete the metadata (I mean, you MUST not!!)
> > 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?
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