Grants on sequences via Grant Wizard

Поиск
Список
Период
Сортировка
От Bartosz Dmytrak
Тема Grants on sequences via Grant Wizard
Дата
Msg-id CAD8_UcZgLvCt_ORo1H=brm7jAUx4VyYb+SXPAnNRxWQ7A3zy_Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Grants on sequences via Grant Wizard
Список pgadmin-support
Дерево обсуждения
Hi all,
I've noticed Grant Wizard (schema node) generates odd SQL to grant privileges on sequence. Sequence is treated as a table, so SQL may look like this:

GRANT SELECT, UPDATE, INSERT, DELETE, REFERENCES ON TABLE "MySchema"."MySeq" TO "MyGroup";

what produces warning message:
WARNING:  sequence "MySeq" only supports USAGE, SELECT, and UPDATE privileges

Of course SELECT is granted :)

My suggestion is to change this behavior to produce SQL dedicated to sequence:
GRANT SELECT ON SEQUENCE "MySchema"."MySeq" TO "MyGroup";

Without (INSERT, UPDATE, etc).
Also there is no USAGE option available in Grant Wizard window (schema node only).

env pgAdmin 1.16.1 on Windows.

Regards,
Bartek

В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: PgAdmin 1.16.1 on Mac OS X 10.8.3: Query Tool broken?
Следующее
От: k mac
Дата:
Сообщение: Re: PgAdmin 1.16.1 on Mac OS X 10.8.3: Query Tool broken?