Re: grant everything on everything and then revoke

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: grant everything on everything and then revoke
Date: 2009-03-03 17:29:17
Message-ID: 49AD68ED.8040309@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo wrote:
> I'd like to have different users mainly to have a different search
> schema path.
> Things may evolve so this is not going to be the only reason to have
> more than one user.
>
> But I'm faced with the problem of granting the same access of the
> owner of the db to the other users.
>
...

have the database owned by a 'ROLE and make your users members of that ROLE.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2009-03-03 17:45:15 Re: How to delete all locks? Re: Strange behavior: row won't delete
Previous Message Phoenix Kiula 2009-03-03 17:25:32 Re: Strange behavior: row won't delete