[GENERAL] Fw: strange problem with not existing roles

2014-09-23 Thread lud...@kni-online.de
4 um 17:08 Uhr Von: "lud...@kni-online.de" An: pgsql-general@postgresql.org Betreff: strange problem with not existing roles Hi list, I have a strange problem in postgres (PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 64-bit), there are granted privileges on schemas, tables, co

Re: [GENERAL] strange problem with not existing roles

2014-09-18 Thread lud...@kni-online.de
contents. But I'm curious about what has caused the problems and how to avoid them...   Ludwig   Gesendet: Donnerstag, 18. September 2014 um 15:53 Uhr Von: "Adrian Klaver" An: "lud...@kni-online.de" , pgsql-general@postgresql.org Betreff: Re: [GENERAL] strange p

Re: [GENERAL] strange problem with not existing roles

2014-09-18 Thread lud...@kni-online.de
ems?   Ludwig Gesendet: Mittwoch, 17. September 2014 um 17:33 Uhr Von: "Adrian Klaver" An: "lud...@kni-online.de" , pgsql-general@postgresql.org Betreff: Re: [GENERAL] strange problem with not existing roles On 09/17/2014 08:08 AM, lud...@kni-online.de wrote: > Hi list

[GENERAL] strange problem with not existing roles

2014-09-17 Thread lud...@kni-online.de
Hi list, I have a strange problem in postgres (PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 64-bit), there are granted privileges on schemas, tables, columns for roles that don't exist. Example: In pgAdmin for schema user_data the follwing wrong grants are reported: ... GRANT ALL ON SCHEM