title: How to revoke privileges on a single table in mysql
body: <p>Before this post, I've got already posted, but i should delete that, because there was some misspelled column names, so that was my fault.</p>
  
  <p>What i want to do is, to grant all privileges to a user to a database. These users will be our partners. My system designs require that, I need 1 table in every partners database, what I will use, and I want to prevent them from doing any operations, but SELECT on that table. (Please skip the WITH GRANT OPTION thing).</p>
  
  <p>The name of the database and name of the user is the same, csp_ytic.</p>
  
  <p>What i did:</p>
  
  <pre><code>CREATE USER 'csp_ytic'@'localhost' IDENTIFIED BY 'somepass'; 
  
  FLUSH PRIVILEGES;
  
  GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, EXECUTE, INDEX, INSERT, LOCK TABLES, REFERENCES, SELECT, SHOW VIEW, TRIGGER, UPDATE ON `csp_ytic`.* TO 'csp_ytic'@'localhost' WITH GRANT OPTION;
  </code></pre>
  
  <p>So with this, I added the user with all the privileges.</p>
  
  <p>After this I revoke the privileges in my table.</p>
  
  <pre><code>REVOKE ALTER, CREATE, CREATE VIEW, DELETE, DROP, INDEX, INSERT, REFERENCES, SHOW VIEW, TRIGGER, UPDATE ON `csp_ytic`.`tag_scanned` FROM 'csp_ytic'@'localhost'; 
  </code></pre>
  
  <p>I thought it's enough.</p>
  
  <p>But when I run my script with this user, I can SELECT, INSERT, UPDATE, and DELETE.</p>
  
  <p>What am I doing wrong? </p>