Re: [HACKERS] user-defined default public acl

2004-04-20 Thread James Robinson
[ discussion re/ default state of minimal rights, as opposed to the more generous situation today snipped ] Just to add fuel to the fire, as an ex-college sys-admin having had to deploy both Oracle and postgres, I would have to say that Oracle allowed me to deploy a database container shared by

Re: [HACKERS] user-defined default public acl

2004-04-13 Thread Fabien COELHO
Dear Tom, > > defaults in "src/backend/utils/adt/acl.c". > > I'm unconvinced that this is a good idea. Hmmm. > In the first place I am unsure what sorts of surprising behaviors might > result from nontraditional defaults for these ACL settings. Sure, this should be thought of. > (I find th

Re: [HACKERS] user-defined default public acl

2004-04-12 Thread Tom Lane
Fabien COELHO <[EMAIL PROTECTED]> writes: > Thus I'd like to add a user defined default public acl for postgresql > database, namespace, class, language and proc, instead of the hardwired > defaults in "src/backend/utils/adt/acl.c". I'm unconvinced that this is a good idea. In the first place I a

[HACKERS] user-defined default public acl

2004-04-12 Thread Fabien COELHO
Dear hackers, I'm used to have a "umask 077", but I cannot have that at the time with postgresql. This fact is among the many various "surprises" I had while discovering postgresql, and this is easy to fix. Thus I'd like to add a user defined default public acl for postgresql database, namespace