Re: grant everything on everything and then revoke - Mailing list pgsql-general

From John R Pierce
Subject Re: grant everything on everything and then revoke
Date
Msg-id 49AD68ED.8040309@hogranch.com
Whole thread Raw
In response to grant everything on everything and then revoke  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: grant everything on everything and then revoke  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
in role, ownership and permissions was: grant everything on everything and then revoke  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List 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.



pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Re: Strange behavior: row won't delete
Next
From: Chris Browne
Date:
Subject: Re: How to delete all locks? Re: Strange behavior: row won't delete