Hi Scott, One would think that you should be able to accomplish what you are looking for by changing rows in table -> "tables_priv" in mysql database. And using "flush privileges" when you done.
mysql> describe tables_priv; +-------------+--------------------------------------------------------- --------------------------------------+------+-----+-------------------+ -------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------------------------------------------------- --------------------------------------+------+-----+-------------------+ -------+ | Host | char(60) | | PRI | | | | Db | char(64) | | PRI | | | | User | char(16) | | PRI | | | | Table_name | char(64) | | PRI | | | | Grantor | char(77) | | MUL | | | | Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | | | Table_priv | set('Select','Insert','Update','Delete','Create','Drop','Grant','Referen ces','Index','Alter') | | | | | | Column_priv | set('Select','Insert','Update','References') | | | | | +-------------+--------------------------------------------------------- --------------------------------------+------+-----+-------------------+ -------+ 8 rows in set (0.00 sec) mysql> See http://dev.mysql.com/doc/refman/4.1/en/request-access.html Paragraph begins with words "After determining the database-specific privileges granted by the db and host table entries" Regards, Mikhail Berman -----Original Message----- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 4:13 PM To: MySql Subject: Table specific privileges (BUMP) Sorry to push this back out to the list, I am stumped, and the docs are not leading me to an answer. One users reply was close, and I had tried it, but it generates an error, which is also posted in this thread. Thanks everyone, original message follows: MySQL - 4.0.18-standard-log How do you revoke all privileges from a user for one table in a database, and still maintain the existing privileges for the other tables? For example, I have these tables: Email Logbook Sales_tax Sessions Transactions Users Orders_A Orders_B Lets say I have two users, user_A and user_B Currently, both users have select, insert, update, and delete on all tables. I want to totally block user_A from touching Orders_B and totally block user_B from touching Orders_A Knowing how to do this the SQL way would help, ultimately, I have to show a client how to do this in phpMyAdmin, so if anyone knows how to do it in there, that would be nice as well. Thanks. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]