## Thiemo Kellner (thi...@gelassene-pferde.biz): > I installed pglogger (https://sourceforge.net/projects/pglogger/) and > try to insert into the "level" table as user "act" but it fails > claiming insufficient privileges even though insert is granted to > public (see below). What am I missing?
Schema privileges. > ERROR: permission denied for schema logger > LINE 1: insert into logger.LEVEL ( It says "permission denied for schema", so this is not about table privileges (GRANT INSERT/UPDATE/... ON TABLE ...), but about schema provileges. I'd guess you miss USAGE on schema logger. See https://www.postgresql.org/docs/current/static/sql-grant.html AFAIK those privileges are not found in information_schema, you'll have to use pg_catalog for that. Regards, Christoph -- Spare Space.
