MySQL Forums
Forum List  »  Newbie

Re: Revoke privileges from user issue!
Posted by: Rick James
Date: August 13, 2011 02:57PM

The privileges are visible in the database mysql.
USE mysql;
SELECT * FROM user WHERE user = 'tempaccess' \G
SELECT * FROM db WHERE user = 'tempaccess' \G

Interpretation:
All 'N' in `user`, plus nothing in `db` = GRANT USAGE -- can't do anything.
All 'N' in `user`, plus stuff in `db` = GRANT ... ON dbname.* ...
Some 'Y' in `user` = GRANT ... ON *.* ...

The `password` column is either '' if no password, or an encryption of the actual password.

REVOKE is finicky. Suggest doing
SHOW GRANTS FOR tempaccess@"%";
Then modifying them to be REVOKEs and running them.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.