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

On 24 Sep, 11:52, Adam <srian...@gmail.com> 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

If it was possible to create a table that was read only, ten you would
not be able to manually add your data!

You can create a table and only publish access as a VIEW.

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.
jstucklex@attglobal.net
==================

Response from Jerry Stuckle <jstucklex@attglobal.net>:

> 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?
>
> No, but you can take the insert, update and delete privileges away
> from everyone else.

If using Windows you could always edit the properties of the database
via policies or simply right-click the file and choose "Read-only."

The smart choice however, irregardless of OS is what Mr. Stuckle
suggested.

Just like administrator accounts and guest accounts. You do not
change the properties of EVERY file (which would lead to having
duplicates or constant updating), instead you limit the access of an
account.

--
-Lost
Remove the extra words to reply by e-mail. Don't e-mail me. I am
kidding. No I am not.

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?

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

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 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, 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
==================

On Mon, 24 Sep 2007 03:52:56 -0700, Adam <sriansri@gmail.com>
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

The archive storage engine, perhaps?
--
( Kees
)
c[_] A chicken is an egg's way of producing more eggs. (#436)