columns_priv : how it works ? [ MySQL 4.1 ]

[Gilles MISSONNIER]

hello,

There is something I obviously missed, can't figure out what, since it 
seems so simple.

as user root (of mysql),
mysql> use mysql;
I can see :
mysql> select * from columns_priv where User='demandeur' order by Column_name;

and I get :
+----------+-------+----------+-----------+------------+-----+-----------+
|Host      |Db     |User      |Table_name |Column_name |time |Column_priv|
+----------+-------+----------+-----------+------------+-----+-----------+
|localhost |people |demandeur |current    |HOMEDIR     |19h30|Select     |
.......


now, as user 'demandeur', on the Db 'people' I got :
mysql> use people;
mysql> select HOMEDIR from current;
    ERROR 1142 (42000): SELECT command denied to user
    'demandeur'@'localhost' for table 'current'


This is not what I would expect from the "Column_priv".

What is wrong ?

(I have done any way "flush privileges;" )

cheers !


_-¯-_-¯-_-¯-_-¯-_
Gilles Missonnier
IAP - gimi@stripped
01 44 32 81 36