Skip to main content

Transfer View Ownership

Comments

2 comments

  • Alon Brody

    You are probably getting the syntax error because you did not use double-quotes. The following is the correct way to use this query:
    alter table "table/view" owner to "user";
    In general, in each query, I would suggest to enclose entities in double-quotes.

    Having said that, you will still get an error because only a superuser can perform a change of ownership. Our support team will be more than happy to help you with this change. All you need to do is email support@panoply.io with the list of tables/views you wish to transfer ownership and the new owner email address.

    0
  • mmorganfield

    Great, thanks Alon! That makes sense, I also noticed I could only see myself when looking at pg_users. I’ll consolidate and send.

    0

Please sign in to leave a comment.

Powered by Zendesk