Postgres Pro
Downloads
Home   >   mailing lists

Re: How to set default owner of objects in Postgresql - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: How to set default owner of objects in Postgresql
Date
Msg-id CAGDYbUM49-=jMVyTPQGkbQhTPMLMoxU=8AxDSwu9GFk1P-1V1g@mail.gmail.com
Whole thread Raw
In response to How to set default owner of objects in Postgresql  (Ashif Shaikh <sashif0@gmail.com>)
Responses Re: How to set default owner of objects in Postgresql  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: How to set default owner of objects in Postgresql  (Ashif Shaikh <sashif0@gmail.com>)
List pgsql-admin
Tree view
Hi Ashif,

When we create any table in a database that table owner is a respective user who created the table. If user ABC creates a table in the database mydb then by default the owner of the object should be ABC (non superuser) later you can change the table owner as xyz by using alter command.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Wed, Jan 16, 2019 at 2:10 PM Ashif Shaikh <sashif0@gmail.com> wrote:
Dear Expert's,

I wanted to know whether it is possible to set default owner of any new objects being created in Postgresql 9.6?

For eg: if user abc creates a table in database mydb then by default the owner of the object should be xyz (non superuser).

Regards,
Ashif Shaikh 

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: How to set default owner of objects in Postgresql
Next
From: Morris de Oryx
Date:
Subject: Re: How to set default owner of objects in Postgresql