Re: How to set default owner of objects in Postgresql

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Ashif Shaikh <sashif0(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to set default owner of objects in Postgresql
Date: 2019-01-16 09:07:51
Message-ID: CAECtzeW4bcu-9VSe+fvN8BwKCEy36yD_iAoZ3waJq1sXG_PifA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Le mer. 16 janv. 2019 à 09:40, Ashif Shaikh <sashif0(at)gmail(dot)com> a écrit :

> 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).
>
>
No. The default owner will always be the user who executes the CREATE
statement.

--
Guillaume.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2019-01-16 09:10:53 Re: How to set default owner of objects in Postgresql
Previous Message Achilleas Mantzios 2019-01-16 08:52:52 Re: Backup solution over unreliable network