MySQL Forums
Forum List  »  Newbie

Re: Lock down table
Posted by: Peter Brawley
Date: July 07, 2016 09:22AM

For each user ...

REVOKE ALL PRIVILEGES, GRANT OPTION ON db.table FROM user;
GRANT SELECT ON db.table TO user;

Or do that for all users than grant all to root and yourdelf if you are not root. And change the root password.

Options: ReplyQuote


Subject
Written By
Posted
July 07, 2016 07:14AM
Re: Lock down table
July 07, 2016 09:22AM
July 07, 2016 09:30AM
July 07, 2016 10:06AM


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.