Solution: User is unable to view stored procedure. root can view it.

[uzair qadir]

Figured out the solution actually no user had rights on myql.proc table so rights granted by running following command. all went well

GRANT SELECT ON mysql.proc TO appuser;