Re: [ADMIN] privilege inheritance to a login role through a group role

2009-04-01 Thread Alvaro Herrera
Tom Lane wrote: If there's some identifiable bit of the documentation that confused you about this, please point it out so we can improve it. ... because, apparently, lots of people are bitten by the same misunderstanding. -- Alvaro Herrera

Re: [ADMIN] privilege inheritance to a login role through a group role

2009-04-01 Thread Jan-Peter Seifert
Hello, Alvaro Herrera wrote: Tom Lane wrote: If there's some identifiable bit of the documentation that confused you about this, please point it out so we can improve it. ... because, apparently, lots of people are bitten by the same misunderstanding. Maybe it's not the documentation

[ADMIN] privilege inheritance to a login role through a group role

2009-03-31 Thread Kasia Tuszynska
Hello Everyone. I am having issues with privilege inheritance to a login role through a group role. These are the steps I am performing: 1. data: stcities belongs to user gdb, it resides in the gdb schema 2. map user is a login role: CREATE ROLE map LOGIN ENCRYPTED PASSWORD

Re: [ADMIN] privilege inheritance to a login role through a group role

2009-03-31 Thread Tom Lane
Kasia Tuszynska ktuszyn...@esri.com writes: I am having issues with privilege inheritance to a login role through a group role. These are the steps I am performing: 1. data: stcities belongs to user gdb, it resides in the gdb schema 2. map user is a login role: CREATE ROLE map LOGIN