How to hide mysql stored procedure -

how hide mysql stored procedure: encryption available in sql server store procedure. try hide stored procedure outside users

as documented under show create procedure syntax:

this statement mysql extension. returns exact string can used re-create named stored procedure. similar statement, show create function, displays information stored functions (see section 13.7.5.10, “show create function syntax”).

both statements require owner of routine or have select access mysql.proc table. if not have privileges routine itself, value displayed create procedure or create function field null.

therfore, prevent users viewing body of stored procedure, ensure that:

• they not owner of sproc; and

• they not have access mysql.proc table.

you can read more the mysql access privilege system.