You can't set the permissions for the database user account yourself. Your host has to do. Zenphoto requires these:
[i]Required user account rights: Select, Create, Insert, Drop, Update, Delete, Index[/i]
http://www.zenphoto.org/2008/08/installation-and-upgrading/