## Thiemo Kellner (thiemo@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.