strange problem with not existing roles
От | ludwig@kni-online.de |
---|---|
Тема | strange problem with not existing roles |
Дата | |
Msg-id | trinity-fbe3bb20-4aa0-491f-8bec-fb0caa5eb0fb-1410966538450@3capp-1and1-bs04 обсуждение исходный текст |
Ответ на | Re: Regarding timezone (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: strange problem with not existing roles
|
Список | pgsql-general |
Hi list, I have a strange problem in postgres (PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 64-bit), there are granted privilegeson 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 SCHEMA user_data TO "482499"; GRANT ALL ON SCHEMA user_data TO "17708"; ... Problem is: - these roles don't exist, - they can't be dropped (DROP ROLE "482499"; => FEHLER: Rolle „482499“ existiert nicht) - grants can't be revoked (REVOKE ALL ON SCHEMA "user_data" FROM "482499"; => FEHLER: Rolle„482499“ existiert nicht) - ROLES can be recreated and dropped afterwards, but the grants persists: CREATE ROLE "482499"; DROP OWNED BY "482499"; REVOKE CONNECT ON DATABASE "wver_ims" FROM "482499"; REVOKE ALL ON SCHEMA "user_data" FROM "482499"; DROP ROLE "482499"; - new tables can't be created in schemas with these grants CREATE TABLE user_data.test ( id serial, PRIMARY KEY (id) ); => FEHLER: Rolle 17708 wurde gleichzeitig gelöscht The roles are not listed in any catalog SELECT * FROM information_schema.xxxxxxx WHERE grantee in ('243683','243666','243689','482499','482499','17708'); Only in pg_auth_members there is a set for each of these roles: SELECT * FROM pg_catalog.pg_auth_members WHERE member in ('243683','243666','243689','482499','482499','17708'); What can I do to get rid of these roles and grants? Ludwig
В списке pgsql-general по дате отправления: