Privilege mess?

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

Предыдущее
От: Aleš Zelený
Дата:
Сообщение: tds_fdw binary column
Следующее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: Privilege mess?