3

I am trying to change the ownership of a table for which I am already the owner. I am also the owner of the database and have the CREATE and USAGE privileges on the PUBLIC schema. I get the following error message:

ts_d=> ALTER TABLE table1 OWNER TO user2;
ERROR:  permission denied for schema public

How to change ownership without logging as superuser?

1 Answer 1

6

You must be a member of both the old and the new owning role, and the target role needs the CREATE privilege on the schema.

2
  • 1
    CREATE privilege on the schema for the target role was the culprit, it now works, many thanks! Oct 12, 2021 at 21:48
  • @SébastienClément If that answer solved your question then you should accept it, so that your question is marked as resolved.
    – user1822
    Oct 14, 2021 at 5:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.