Re: [BUGS] BUG #4537: role

2008-11-17 Thread Tom Lane
"Marco Peixoto" <[EMAIL PROTECTED]> writes: > CREATE ROLE r227602 LOGIN > ENCRYPTED PASSWORD 'md5a4d27e81e0dc6b9828cf2dc84565fb59' > NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; > GRANT agd_select TO r227602; You've got the role set to NOINHERIT. This means that it can *become* agd_select

[BUGS] BUG #4537: role

2008-11-17 Thread Marco Peixoto
The following bug has been logged online: Bug reference: 4537 Logged by: Marco Peixoto Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.11 Operating system: debian 4.1 Description:role Details: CREATE SCHEMA agd AUTHORIZATION postgres; GRANT ALL ON SCHEMA