>> ALTER SEQUENCE ... OWNER TO ...; >> GRANT ... ON SEQUENCE ... TO ...; >> ... >> > >I don't quite understand why it should be your way and not the other. Care >to >explain? > >Regards. > > >-- >Guillaume.
Oops, sorry, there is no syntax ALTER SEQUENCE ... OWNER TO ...; But since release 8.2, GRANT ON SEQUENCE is available. As written in the release notes, "GRANT ON TABLE for sequences is still supported for backward compatibility". It's quite easy to explain the reason to make such a modification. As also written in the release notes mentioned above, "this <GRANT ON SEQUENCE> was added for setting sequence-specific permissions". It might be strange for someone to operate a command like "GRANT USAGE ON TABLE ..." generated for a sequence, since there is no meaningful USAGE privilege for tables. Although it is correct and works. Dmitry. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
