Re: Revoke all privileges on *.* doesn't work

2005-03-10 Thread Nico Sabbi
Caron, Christian wrote: mysql> show grants for user3; +---+ | Grants for [EMAIL PROTECTED]| +---+ | GRANT USAGE ON *.* TO 'user3'@'%' | +---+ 1 row in set (0.00 sec) what am I doing wrong

RE: Revoke all privileges on *.* doesn't work

2005-03-10 Thread Paul DuBois
At 11:01 -0500 3/10/05, Caron, Christian wrote: > > mysql> show grants for user3; > +---+ > | Grants for [EMAIL PROTECTED]| > +---+ > | GRANT USAGE ON *.* TO 'user3'@'%' | > +---+

RE: Revoke all privileges on *.* doesn't work

2005-03-10 Thread Caron, Christian
> > mysql> show grants for user3; > > +---+ > > | Grants for [EMAIL PROTECTED]| > > +---+ > > | GRANT USAGE ON *.* TO 'user3'@'%' | > > +---+ > > 1 row in set (0.00 sec) > > > > what am

Re: Revoke all privileges on *.* doesn't work

2005-03-10 Thread SGreen
Nico Sabbi <[EMAIL PROTECTED]> wrote on 03/10/2005 10:46:37 AM: > Hi, > the documentation reads: > > REVOKE /|priv_type|/ [(/|column_list|/)] [, /|priv_type|/ > [(/|column_list|/)]] ... > ON {/|tbl_name|/ | * | *.* | /|db_name|/.*} > FROM /|user|/ [, /|user|/] ... > REVOKE ALL PRIVILEGES

Re: Revoke all privileges on *.* doesn't work

2005-03-10 Thread Jigal van Hemert
From: "Nico Sabbi" > mysql> show grants for user3; > +---+ > | Grants for [EMAIL PROTECTED]| > +---+ > | GRANT USAGE ON *.* TO 'user3'@'%' | > +---+ > 1 row in set (0.00 sec) > > what am