only select privilege

[Ananda Kumar]

How do i give only select privilege to a specific database.

I did this

GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab';


FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> select select_priv from user where user='qa';
+-------------+
| select_priv |
+-------------+
| N           |
+-------------+
But is shows as "N". Can you please help me.



regards

anandkl