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)
