On Jan 9, 2008 11:19 AM, Kristian Waagan <[EMAIL PROTECTED]> wrote: > Amir Michail wrote: > > On Jan 9, 2008 3:02 AM, Kristian Waagan <[EMAIL PROTECTED]> wrote: > >> Amir Michail wrote: > >>> On Jan 8, 2008 7:22 PM, Amir Michail <[EMAIL PROTECTED]> 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?
ubuntu linux ext3 Amir > 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 > >> > >
