Re: Privilege mess?

## Thiemo Kellner (thiemo(at)gelassene-pferde(dot)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.