I keep getting the error:
ERROR 1147: There is no such grant defined for user 'username' on host
'host.example.com' on table 'orders_npfs'


> Sean,
> As http://dev.mysql.com/doc/refman/5.0/en/revoke.html states,
> REVOKE ALL ON `database`.`table` FROM 'user'@'hostname';
> 
> 
>> 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.

-- 
-------------------------------------------------------------
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]

Reply via email to