Hi, Try to do that :
GRANT SELECT ON abc.* to 'qa'@'%' identified by 'qa'; flush privileges; Explain : The user qa have access of all tables of user abc. In this command, only SELECT is possible is you connect using user qa. Regards, Juan On 6/8/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
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
