Captain Paralytic <paul_lautman@yahoo.com> wrote in
news:1190640272.402040.139170@19g2000hsx.googlegro ups.com:

> On 24 Sep, 12:40, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> Adam wrote:
>> > Hello All,
>>
>> > I want to create a table read only that it should not be alter
>> > through query, i will manually add some sensitive data in the
>> > table. Is it possible in MySql to create a table read only?
>>
>> > Please Help
>>
>> > Thanks in Advance
>>
>> No, but you can take the insert, update and delete privileges away
>> from everyone else.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================
>
> But isn't this at a database rather than at a table level?

Nope... I'd imagine it's much like

REVOKE insert,delete,update ON mydatabase.mytable FROM username