Regarding the admin of a MySQL database; I am a bit confused as to exactly what privileges must be granted for a user to have read/write/edit/delete/etc. to a database that is accessed in an ASP.NET application?

Trial and error has shown me that granting all privileges to a user for a particular database in the MySQL admin tool will allow the user to connect to the database, but not run a stored procedures in that database. If I grant access to the “Information Schema” and the”mysql” databases then the user can access the stored procedure from within ASP.NET.

So my question is… what exactly is too much permission and what is the minimum permissions that should be granted to allow full access to a MySQL database without giving away the keys to the shop?

Thanks