Subject | Re: [firebird-support] How to hide the database structure from prying eyes? |
---|---|
Author | Carlos H. Cantu |
Post date | 2008-10-15T20:02:08Z |
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
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