List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 22 2001 10:50pm
Subject:Re: Revoke ALL PRIVILEGES not working as expected?
View as plain text  
At 1:39 PM -0800 6/22/01, Joshua J. Kugler wrote:
>I have read the manual about GRANT/REVOKE syntax.  I have set up several
>queries that worked to grant privileges, but then I sent this query to the
>MySQL server:
>
>REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'xxx.xxx.xxx.xxx'
>
>testruser is a user that has an entry in the user table, as well as several
>entries in the tables_priv table.  (Yes, the IP addresses match)  After this
>query is run, the entry is still in the user table, and all the entries are

REVOKE doesn't remove the record from the user table, just any global
privileges the user might have.  You have to DELETE the record manually.
Not sure why you're still ending up with tables_priv records.

>still in the tables_priv table.  Am I missing something, or is this not
>working as expected?
>
>MySQL 3.23.38
>
>Thanks!
>
>j----- k-----
>
>--
>Joshua Kugler, Information Services Director
>Associated Students of the University of Alaska Fairbanks
>isd@stripped, 907-474-7601


-- 
Paul DuBois, paul@stripped
Thread
Revoke ALL PRIVILEGES not working as expected?Joshua J. Kugler22 Jun
  • Re: Revoke ALL PRIVILEGES not working as expected?Paul DuBois23 Jun