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 I doing

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, GRANT

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 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'@'%' | +---+ 1 row

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