Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why opensource database like Postgresql and Mysql don't have encrypted stored proc?

Why opensource database like Postgresql and Mysql don't have encrypted stored proc?

Is it because of their innate open source philosophy?

What are the compelling reasons to encrypt the stored procs?

like image 695
Hao Avatar asked Jan 25 '26 14:01

Hao


1 Answers

While I'm sure encrypted stored procs are a simple matter of programming in PostgreSQL at least (MySQL and stored procs do not have a long history together), with PgSQL's custom languages support, I don't see why this would be useful. They would need to be decrypted at some point to execute them so anyone who administers the database/database server would be able to, with sufficient skill, be able to get the unencrypted sp. The DBA can already see all the data, all the relationships, seemingly making obfuscating the SP code pointless.

like image 163
MkV Avatar answered Jan 27 '26 06:01

MkV



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!