 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
roberto smith
Guest
|
 Posted: Wed Jul 07, 2004 1:26 pm Post subject: How to protect Firebird Stored Procedure Source Code |
 |
|
Hi,
I have read an article by Miguel Angel Suárez Rodríguez that shows the
sample code to protect Interbase Stored Procedure Source Code:
UPDATE RDB$PROCEDURES
SET RDB$PROCEDURE_SOURCE = NULL
WHERE RDB$SYSTEM_FLAG = 0;
I try to run the same code in Firebird 1.5, it doesn't seem to work, the
source code is still readable, any advice will be appreciated.
regards,
roberto smith
|
|
| Back to top |
|
 |
Thomas Steinmaurer
Guest
|
| Posted: Wed Jul 07, 2004 1:53 pm Post subject: Re: How to protect Firebird Stored Procedure Source Code |
|
|
| Quote: | I have read an article by Miguel Angel Suárez Rodríguez that shows the
sample code to protect Interbase Stored Procedure Source Code:
UPDATE RDB$PROCEDURES
SET RDB$PROCEDURE_SOURCE = NULL
WHERE RDB$SYSTEM_FLAG = 0;
I try to run the same code in Firebird 1.5, it doesn't seem to work, the
source code is still readable, any advice will be appreciated.
|
Try:
UPDATE
RDB$PROCEDURES
SET
RDB$PROCEDURE_SOURCE = NULL
WHERE
RDB$SYSTEM_FLAG = 0
OR RDB$SYSTEM_FLAG IS NULL;
Don't forget to commit the update statement.
Mind you, when extracting a DDL script for the entire database using
either isql.exe or a third-party tool, the script won't have the stored
procedure source included, so you won't be able to recreate the
database from that script.
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com
|
|
| Back to top |
|
|
roberto smith
Guest
|
| Posted: Thu Jul 08, 2004 4:09 am Post subject: Re: How to protect Firebird Stored Procedure Source Code |
|
|
Hi Thomas,
Thanks, it works now.
regards,
roberto smith
Thomas Steinmaurer wrote:
| Quote: | I have read an article by Miguel Angel Suárez Rodríguez that shows the
sample code to protect Interbase Stored Procedure Source Code:
UPDATE RDB$PROCEDURES
SET RDB$PROCEDURE_SOURCE = NULL
WHERE RDB$SYSTEM_FLAG = 0;
I try to run the same code in Firebird 1.5, it doesn't seem to work, the
source code is still readable, any advice will be appreciated.
Try:
UPDATE
RDB$PROCEDURES
SET
RDB$PROCEDURE_SOURCE = NULL
WHERE
RDB$SYSTEM_FLAG = 0
OR RDB$SYSTEM_FLAG IS NULL;
Don't forget to commit the update statement.
Mind you, when extracting a DDL script for the entire database using
either isql.exe or a third-party tool, the script won't have the stored
procedure source included, so you won't be able to recreate the
database from that script.
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
