Subject Re: [firebird-support] How to hide the database structure from prying eyes?
Author Carlos H. Cantu
Z> How exactly do I hide the triggers and stored procedures? Guess
Z> that would be better than nothing!

To hide source of procedures:

UPDATE rdb$procedures
SET rdb$procedure_source = NULL
WHERE ((rdb$system_flag = 0) OR (rdb$system_flag IS NULL))

To hide source of triggers:

UPDATE rdb$triggers a
SET rdb$trigger_source = NULL
WHERE ((rdb$system_flag = 0)
OR (rdb$system_flag IS NULL))
AND NOT EXISTS(
SELECT rdb$trigger_name FROM rdb$check_constraints
WHERE rdb$trigger_name=a.rdb$trigger_name)


For obvious reason, take care to not apply it in your "master"
database (the one you use for development).

Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br