A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case of the database owner/administrator not having SUPER privilege.
Lacking SUPER privilege means you cannot use the DEFINER clause when creating Stored Procedures.
That in turn, means, you cannot lock-down your tables to be inaccessible to a given user while at the same time granting that same user indirect access via a Stored Procedure.
Is there an alternative way of accomplishing the same "no direct table access" security strategy without SUPER?