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
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? |