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

2016-07-27 Thread Tom Lane
Billal Mahmood 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

[GENERAL] How to give complete ownership of a new DB to a new user (non-SU)?

2016-07-27 Thread Billal Mahmood
Hi, *Problem Summary:* I'm facing changing ownership issue for a DB and all its DB objects (DB, schema, tables, sequences etc ownership). *Experience So Far:* As per my knowledge and experience every DB being created use a DB template at the time of creation (default to "template1"). If "WITH OWN