Re: How to give complete ownership of a new DB to a new user (non-SU)?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Billal Mahmood <billal(dot)mahmood(at)rolustech(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to give complete ownership of a new DB to a new user (non-SU)?
Date: 2016-07-27 18:57:17
Message-ID: 9988.1469645837@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Billal Mahmood <billal(dot)mahmood(at)rolustech(dot)com> writes:
> *Problem Summary:*
> I'm facing changing ownership issue for a DB and all its DB objects (DB,
> schema, tables, sequences etc ownership).

While there's no magic single statement for this, I think you'll find
that REASSIGN OWNED takes most of the drudgery out of it, if you have
the template database set up properly.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2016-07-27 19:25:41 Re: Uber migrated from Postgres to MySQL
Previous Message Rakesh Kumar 2016-07-27 18:10:04 Re: Uber migrated from Postgres to MySQL