Postgres Pro
Downloads
Home   >   mailing lists

Re: Users, groups and inheritance questions - Mailing list pgsql-general

From Tom Lane
Subject Re: Users, groups and inheritance questions
Date
Msg-id 9601.1206717149@sss.pgh.pa.us
Whole thread Raw
In response to Users, groups and inheritance questions  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-general
Tree view 
Glyn Astill <glynastill@yahoo.co.uk> writes:
> I thought that if user 'test' was in group 'admins' and I specified INHERIT then it'd inherit those permissions?

No, inheritance of permissions only works for GRANT-able permissions;
the special role properties like CREATEDB are outside that scope.

I think though that if test does "SET ROLE admins" then she'd be
able to create a database.

            regards, tom lane

pgsql-general by date:

Previous
From: carty mc
Date:
Subject: creating a trigger to access another postgres database?
Next
From: brian
Date:
Subject: Re: table of US states' neighbours