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 - [EMAIL PROTECTED]
01 44 32 81 36
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
