Grants on sequences via Grant Wizard

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Grants on sequences via Grant Wizard
Date: 2013-05-02 08:21:42
Message-ID: CAD8_UcZgLvCt_ORo1H=brm7jAUx4VyYb+SXPAnNRxWQ7A3zy_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message k mac 2013-05-02 12:55:02 Re: PgAdmin 1.16.1 on Mac OS X 10.8.3: Query Tool broken?
Previous Message Dave Page 2013-05-02 07:23:30 Re: PgAdmin 1.16.1 on Mac OS X 10.8.3: Query Tool broken?