[GENERAL] Problem with roles and permissions

2008-07-01 Thread Chandra Barnett
didn't know to do. In MySQL, for example, after changing permissions, one needs to "flush privileges" to get everything to take effect. Is there something analogous to this in PostgreSQL? If so, can someone tell me how to do it via pgAdmin III? For context, I'm using Pos

Re: [GENERAL] Problem with roles and permissions

2008-07-01 Thread Chandra Barnett
That did it! Thanks, all. (Out of curiosity, what's the reason for not making this the default? It seems to me that if you're making a role a child of another role, it's /because/ you want to inherit permissions. OTOH maybe defaulting to more security is smart enough to be worth the confusion.

Re: [GENERAL] Problem with roles and permissions

2008-07-02 Thread Chandra Barnett
Bah. Must be pgAdmin, then. In its role creation dialogue, INHERIT is definitely off by default. Guess that's not you guys, though. Sorry to have impugned your judgement... =) -cb. "Chandra Barnett" <[EMAIL PROTECTED]> writes: > That did it! Thanks, all. >