Afficher un message
Vieux 24/09/2007, 19h53   #7
Jerry Stuckle
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: How to create Read Only Table

Captain Paralytic wrote:
> 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
>>> 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, you can do it at the table level, also. Just not row or column.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
  Réponse avec citation
 
Page generated in 0,05822 seconds with 9 queries