Postgres Pro
Downloads
Home   >   mailing lists

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

From Guillaume Lelarge
Subject Re: How to set default owner of objects in Postgresql
Date
Msg-id CAECtzeW4bcu-9VSe+fvN8BwKCEy36yD_iAoZ3waJq1sXG_PifA@mail.gmail.com
Whole thread Raw
In response to How to set default owner of objects in Postgresql  (Ashif Shaikh <sashif0@gmail.com>)
List pgsql-admin
Tree view
Hi,

Le mer. 16 janv. 2019 à 09:40, Ashif Shaikh <sashif0@gmail.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.

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Backup solution over unreliable network
Next
From: Shreeyansh Dba
Date:
Subject: Re: How to set default owner of objects in Postgresql