> 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.
So does this mean my database privs of select, insert, update, and delete
supercede any tabl
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;
+-+-
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-sta
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?
F
