Re: tables_priv not working

2002-01-16 Thread nod

On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
 I can't get table-specific grants to work.


snip

Have you flush privileges ?

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: tables_priv not working

2002-01-16 Thread Hamlin Nicholas-qa568

On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
 I can't get table-specific grants to work.


snip

Have you flush privileges ?

Yes.  That didn't change it.


Nicholas

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: tables_priv not working

2002-01-16 Thread nod

On Wednesday 16 Jan 2002 8:50 pm, Hamlin Nicholas-qa568 wrote:
 On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
  I can't get table-specific grants to work.
 
 snip
 
 Have you flush privileges ?

 Yes.  That didn't change it.


I think I've got it, from the manual section 4.2.9 :-

http://www.mysql.com/doc/R/e/Request_access.html

The tables_priv and columns_priv tables are sorted on the Host, Db, and User 
fields.This is similar to db table sorting, although the sorting is simpler 
because only the Host field may contain wild cards.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php