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?
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
