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
>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?
>Joshua Kugler, Information Services Director
>Associated Students of the University of Alaska Fairbanks
Paul DuBois, paul@stripped