On Fri, Nov 16, 2018 at 03:17:59PM -0500, Tom Lane wrote:
> Stephen Frost <sfrost@snowman.net> 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
