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)
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 |