Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can I obfuscate the SQL code in MySQL?

I'm trying to find some way to obfuscate SQL code in MySQL.

In the Oracle databases exists the "wrap" funcionality, but I didn't found some similar. Some ideas?

The final goal is that the client has some difficuties to understand the code.

like image 625
Tremal Naik Avatar asked Nov 04 '22 03:11

Tremal Naik


1 Answers

I think MySQL do not have the ability to obfuscate the code. You can encapsulate the whole SQL query code by creating a STORED PROCEDURE, although not encapsulated but at least your whole SQL query is not shown when used inside your code (PHP, .Net, and the like...).

like image 80
John Woo Avatar answered Nov 07 '22 22:11

John Woo