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?
Near the bottom it says:
USAGE || Synonym for ``no privileges''
So, you succesfully removed all privileges!
good to know :) , but ...
That's something that always bugged me... If you really want to remove a user from your interface, you'll have to do it manually in the table. But why has it been implemented this way?
If I want to remove a user, I don't want him/her to have no privileges, I want him/her to be completely out of the database...
Anyone knows why they chose this route?
Christian
I totally agree: I would like mysql to kill or forget the existence of that user.
Besides, I'm not supposed to mess with a dbms' internal tables, nor to know
how/where grants are stored.
-- Nico Sabbi - Officine Digitali - Bologna Tel. 051 - 4187565
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]