I have a database with a certain user that should only be able to access some of the fields in one of the tables.

The user exists in the user-table and I have added him to the db-table and table_priv table with all privileges set to 'N'

The user has then been given select-privileges on some of the fields using the columns_priv table

But now when I log on as this user and write 'use dbname' I get an access denied error.

However if I add select-privileges to the user in the db-table, then it works - but then he will be able to select anything from the table, which he was not supposed to do...

How can I grant the user access to 'use' the database without giving him select-options on more than a few fields?