"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
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