On Fri, Nov 16, 2018 at 03:17:59PM -0500, Tom Lane wrote: > Stephen Frost <sfrost@xxxxxxxxxxx> writes: > > There was much discussion of being able to have 'FOR ALL ROLES' or > > similar for ALTER DEFAULT PRIVILEGES when it went in, but there was a > > lot of concern about one user getting to define the default privileges > > for objects created by some other user. > > Yeah, it's hard to see how you could allow such a command to anybody > but a superuser. > I have some applications using specific schema. I don't wan't them to be superuser, but I wan't them to be able to access any table in that schema. Because many users are able to create tables in that schema, I have to write one ALTER DEFAULT PRIVILEGE foreach user. Any chance to have superuser per schema ? -- nicolas
