开发者

mySql stored procs encryption

I am looking into ways to encrypt mySQL stored procedure source code when installed in clients local environment.

I did lot of research on this topic and had no luck except for one promising reply from gazzang.com

Here is the reply from gazzang. Let me know if someone has already tried this out.

We should be able to encrypt the table where store procs and functions are stored - mysql.proc Thus os users won't be able to read the contents of the sp or functions. I can't remember which internal table views are stored in but the same some apply to them. I am not sure we could come up with a solution to encrypt the routines interna开发者_运维问答l to mysql. Other databases that do this really implement "obfuscation" internally - I think PostgreSQL does that for example.


You cannot encrypt stored procedures in a really useful way, because MySQL server will have to decrypt it anyway when it reads stored procedure from it's tables. If you encrypt the table file, your customer will login as root and make dump on mysql.proc table using native MySQL statements. If you change root password, they will always have a way to start MySQL with --skip-grant-tables switch to overcome that.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜