Privilege mess?

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Privilege mess?
Date: 2018-10-09 19:26:29
Message-ID: 20181009192629.Horde.3cygsKW_Jo7dLVp26E2y0cg@webmail.gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all

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?

Kind regards Thiemo

thiemo @ thiemos-toshi ~/external_projects/pg-scd-code/trunk :-( %
psql -U act
psql (10.5 (Debian
10.5-1.pgdg90+1))
Type "help" for help.

act=> insert into logger.LEVEL (
act(> SCOPE,
act(> LEVEL
act(> ) values (
act(> 'inline_code_block',
act(> 'INFO'
act(> );
ERROR: permission denied for schema logger
LINE 1: insert into logger.LEVEL (
^
act=> SELECT grantor, grantee, table_catalog, table_schema,
table_name, privilege_type
act-> FROM information_schema.table_privileges
act-> WHERE grantor = 'logger'
act-> AND table_schema = 'logger'
act-> AND table_name = 'level';
grantor | grantee | table_catalog | table_schema | table_name |
privilege_type
---------+---------+---------------+--------------+------------+----------------
logger | PUBLIC | act | logger | level | INSERT
logger | PUBLIC | act | logger | level | SELECT
logger | PUBLIC | act | logger | level | UPDATE
logger | PUBLIC | act | logger | level | DELETE
(4 rows)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2018-10-09 20:56:03 Re: Privilege mess?
Previous Message Aleš Zelený 2018-10-09 19:07:03 tds_fdw binary column