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.
Subject
Written By
Posted
Re: Revoke privileges from user issue!
August 13, 2011 02:57PM
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.