On Fri, Jun 08, 2007 at 03:14:18PM +0530, Ananda Kumar wrote: > How do i give only select privilege to a specific database. > > GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab';
Like that. > mysql> select select_priv from user where user='qa'; > +-------------+ > | select_priv | > +-------------+ > | N | > +-------------+ > But is shows as "N". Can you please help me. If that was 'Y' then the user would have select privileges on *all* databases. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]