Hi Juan, Do you me "all table in database abc". Please confirm.
Is it a typo or something else. regards anandkl On 6/8/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote:
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 >
