Re: [GENERAL] Remove or alter the default access privileges of the public schema by the database owner

2013-10-17 Thread Christian Affolter
med the mailing list admins that I will resend the message with a new subject and that they can safely delete the original message. Apparently, my notice got overlooked somehow. Sorry again. Christian On 15.10.2013 12:28, Christian Affolter wrote: Hi everyone I'm looking for a way to let

[GENERAL] Remove or alter the default access privileges of the public schema by the database owner

2013-10-17 Thread Christian Affolter
Hi everyone I'm looking for a way to let a role which created a new database (is the database owner) change (remove) the default access privileges of the public schema, which allows everyone to use and create objects within this schema. I do not want to give the role the SUPERUSER option.

[GENERAL] Alter the default access privileges of the public schema by the db owner

2013-10-15 Thread Christian Affolter
Hi everyone I'm looking for a way to let a role which created a new database (the database owner) change (remove) the default access privileges of the public schema, which allows everyone to use and create objects within this schema. I do not want to give the role the SUPERUSER option.