SHOW PROTECTION and SHOW PRIVILEGES are invalid on stored
  procedures

  Explanation:  The specified routine is a stored procedure.
  Because the GRANT and REVOKE statements are only allowed on the
  module level, you cannot SHOW PROTECTION or SHOW PRIVILEGES on a
  stored procedure.

  User Action:  Specify the SHOW PROTECTION or SHOW PRIVLEGES
  statements on the stored module.