Who should be the owner of Jira tables and plugin tables in a Postgres database?

[Terry Beavers]

We are seeing some weird errors in our atlassian-jira.log related to database table ownership, so I would like to confirm what database user should own the actual database tables in a Postgres database for Jira tables and tables associated with plugins?

My understanding is that it should NOT be the database user specified in the dbconfig.xml file for connecting to the Jira database, but our database team is reporting we have some tables owned by rpg_master and some by jiradbuser, which is the user we have configured for connection in the dbconfig.xml file.

Please advise.

Thanks in advance for your support,

Terry

[Radek Dostál · Accepted solution]

It doesn't really "matter" who owns the tables - it makes sense for the jira user to own it (and it really should because it should also be the one creating them), but it's the permissions that matter at the end of the day.

At https://confluence.atlassian.com/adminjiraserver100/connecting-jira-applications-to-postgresql-1442844883.html

it is stated to 

GRANT ALL PRIVILEGES ON DATABASE <Database Name> TO <Role Name>

It doesn't practically need "all" of them (there's only really about 2 handfuls of permissions it makes use of), but that's what the documentation states.

So, as long as your jiradbuser has all permissions, it should be fine.

However, I would expect jiradbuser to also own the tables, since it should be the one creating them. When you install a fresh Jira and connect it to an empty database, that's what it would do.