Re: [GENERAL] grant everything on everything and then revoke

2009-03-03 Thread Ivan Sergio Borgonovo
On Tue, 03 Mar 2009 09:29:17 -0800 John R Pierce wrote: > 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 t

Re: [GENERAL] grant everything on everything and then revoke

2009-03-03 Thread John R Pierce
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 use

Re: [GENERAL] grant everything on everything and then revoke

2009-03-03 Thread John DeSoi
On Mar 3, 2009, at 4:35 AM, Ivan Sergio Borgonovo wrote: But I read: http://www.postgresql.org/docs/8.3/static/sql-grant.html The SQL standard does not support setting the privileges on more than one object per command. This is going to make maintenance and development a PITA every time I add

[GENERAL] grant everything on everything and then revoke

2009-03-03 Thread Ivan Sergio Borgonovo
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. But I read: http://www.po