db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: how to recover from read only connection error?
Date Wed, 09 Jan 2008 16:19:02 GMT
Amir Michail wrote:
> On Jan 9, 2008 3:02 AM, Kristian Waagan <Kristian.Waagan@sun.com> wrote:
>> Amir Michail wrote:
>>> On Jan 8, 2008 7:22 PM, Amir Michail <amichail@gmail.com> wrote:
>>>> Hi,
>>>>
>>>> How do I recover from this error?
>>>>
>>>> ERROR 25503: DDL is not permitted for a read-only connection, user or database.
>>>>
>>>> Amir
>>>>
>>> It turns out that not only do permissions need to be good, but also ownership.
>> Just for completeness, are you talking about file system ownership here?
>> It would also be nice to know what kind of operation/statement gave you
>> the error.
>>
> 
> Yes, I mean file system ownership.  It's not enough to just give
> everyone read/write permission.  You need to have correct ownership.
> This is surprising.

Yes, it is to me as well.
What is your OS and file system?
I might play around a little with this on my own system to see what 
behavior I get.

Can anyone else enlighten us on this issue?


-- 
Kristian

> 
> I got an error with any operation that made changes to the data.
> 
> Amir
> 
>>
>> thanks,
>> --
>> Kristian
>>
>>> Amir
>>


Mime
View raw message