Privilege mess?
От | Thiemo Kellner |
---|---|
Тема | Privilege mess? |
Дата | |
Msg-id | 20181009192629.Horde.3cygsKW_Jo7dLVp26E2y0cg@webmail.gelassene-pferde.biz обсуждение исходный текст |
Ответы |
Re: Privilege mess?
|
Список | 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)
В списке pgsql-general по дате отправления: