Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER DEFAULT PRIVILEGES FOR ROLE is broken - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: ALTER DEFAULT PRIVILEGES FOR ROLE is broken
Date
Msg-id 517EEE3E.3030808@agliodbs.com
Whole thread Raw
In response to ALTER DEFAULT PRIVILEGES FOR ROLE is broken  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
Tom,

I'm also seeing that the DEFAULT PRIVs I get seem to be dependant on my
login role, not my current role.  That is, if role "dba" has default
privs set, and role "josh", which is a member of "dba" does not, and
"josh" does "set role dba" before creating some tables, those tables do
NOT get dba's default privs.  At least, that's what happens in my testing.

Is that expected?  If so, that should certainly be documented.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Remaining beta blockers
Next
From: Fabien COELHO
Date:
Subject: Re: [PATCH] add --throttle option to pgbench [patch 2]