How do I grant a user access to all tables in a databse?

e.g.

grant ALL on tablename to username;


thats fine but what if there are 200 tables in the database and I want to grant the user access to all of them as in :

GRANT ALL ON * TO user;

?