Owner and privileges on sequences
- From: "Dmitry Samokhin" <sdld(at)mail(dot)ru>
- To: pgadmin-support(at)postgresql(dot)org
- Subject: Owner and privileges on sequences
- Date: Fri, 9 Oct 2009 11:50:22 +0400
- Message-id: <hampvl$kol$1@news.hub.org> <text/plain>
For sequences, the DDL script generated looks like:
CREATE SEQUENCE ...;
ALTER TABLE ... OWNER TO ...;
GRANT ... ON TABLE ... TO ...;
...
... but should be:
...
ALTER SEQUENCE ... OWNER TO ...;
GRANT ... ON SEQUENCE ... TO ...;
...
Regards,
Dmitry.
Home |
Main Index |
Thread Index