On Wed, Jul 2, 2008 at 6:09 PM, Chandra Barnett
<[EMAIL PROTECTED]> wrote:
>
>
> 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... =)
Fixed in SVN. Sorry for the confusi
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.
> (Out of curiosity, what's
"Chandra Barnett" <[EMAIL PROTECTED]> writes:
> That did it! Thanks, all.
> (Out of curiosity, what's the reason for not making this the default?
Uh ... it *is* the default.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
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.
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Probably your group role needs to have the INHERIT property set.
I think it's the other way around --- the login role needs the INHERIT
property. Anyway, one or the other should do it.
regards, tom lane
--
Sent via pgsql-gene
Chandra Barnett wrote:
> What I've done so far is to set up a "group role" and explicitly
> granted it every possible type of permission on the database in
> question, and also on the individual relations in that database. Then
> I created a "login role" and made it part of the group role I create
Hi --
I've recently started using PostgreSQL after working with MySQL for quite a
while. I've been trying to set up roles so I can manage permissions per-user,
but it's not working the way I expected and I'm wondering if anyone can steer
me straight.
What I've done so far is to set up a "g
