CODEWITHSUNDEEP
mysqldatabase
Anaya Upadhyay
Anaya Upadhyay

Reputation: 45

How to encrypt stored procedures in MySQL?

I need to encrypt stored procedures in MySQL. Since I was doing the database work on Oracle and all of my stored procedures are encrypted, I needed to migrate from Oracle to MySQL so as this problem came.

Upvotes: 2

Views: 3651

Answers (2)

Hardik Patel
Hardik Patel

Reputation: 716

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.

You can protect your Stored Procedure Code as like this in SQL Server.This is not for MySql but this is for SQL Server.

How Do I Protect My Stored Procedure Code?

Upvotes: 1

Rahul Tripathi
Rahul Tripathi

Reputation: 172378

I dont think there is a way to encrypt stored procedure in MYSQL. I would recommend you to change the priviledge for the users for which, whom you dont want that they should access your stored procedure.

You can see this bug reported in MYSQL: Bug #4210 Stored Procedure Encryption and also Bug #19516 stored procedur encoding/obfuscating

Upvotes: 3

Related Questions