Hi.
AFAIK, a table is considered read only, if either the underlying
filesystem says so (what you called OS attribute) or it is a
compressed table.
If it would be a problem with the privileges, you would rather get an
error like "Access denied for ... to ...".
So your problem is quite probably that the user, the MySQL daemon is
running as, has not right to access the database file. I do not know
how it is supposed to look like under NT or how to change it as I do
not use NT.
Regards,
Benjamin.
On Fri, May 24, 2002 at 10:04:49AM -0400, [EMAIL PROTECTED] wrote:
> Hi,
> I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a
> password is required for access.
> Both GRANT and REVOKE give errors saying "Table 'User' is read only". A text
> search in the manual for "read only" did not yield anything.
> Is this an OS attribute that should be dealt with manually, such as with
> Windows-NT explorer or DOS ATTRIB? Or is there a MySQL command that should
> be used to make tables read-only and read-write?
>
> Thanks,
> Rick
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
