rights for schema

From: Philipp Kraus <philipp(dot)kraus(at)flashpixx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: rights for schema
Date: 2012-12-30 14:54:32
Message-ID: BE882417-4544-459C-8478-8AC0593E807C@flashpixx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

can I set all rights to a schema and its content? I have different schema and in the public schema all users should be do everything (select, update, delete, call functions, etc).
Also if I add a new user, the user should be get also the rights.
My other schemas are only access by the database user only.

How can I do this?

Phil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2012-12-30 15:03:23 bug with indexing of infinite timestamps?
Previous Message Amit kapila 2012-12-30 09:15:21 Re: Cursor fetch Problem.