Re: [pgadmin-support] Grants on sequences via Grant Wizard

2013-05-13 Thread Bartosz Dmytrak
Hi, one self correction: UPDATE - is available for sequences - my mistake. Thanks for your attention. Regards, Bartek

Re: [pgadmin-support] Grants on sequences via Grant Wizard

2013-05-07 Thread Dave Page
Dhiraj, can you look at this please? Thanks. On Thu, May 2, 2013 at 9:21 AM, Bartosz Dmytrak 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, INSE

[pgadmin-support] Grants on sequences via Grant Wizard

2013-05-02 Thread Bartosz Dmytrak
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: sequenc

[pgadmin-support] Grants

2006-11-30 Thread Ezequias Rodrigues da Rocha
Hi list, I am having problem with grants and users on PostgreSQL. I am using pgAdmin to connect like other user to test my permissions. As the owner of the database I have criated two roles: administrators (cannot connect) ezequias (can connect) I give permissions to a table I have: GRANT SEL