Dhiraj, can you look at this please? Thanks.
On Thu, May 2, 2013 at 9:21 AM, Bartosz Dmytrak <bdmyt...@gmail.com> wrote: > 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 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
