Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Owner and privileges on sequences


  • From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
  • To: pgadmin-support(at)postgresql(dot)org, "Dmitry Samokhin" <sdld(at)mail(dot)ru>
  • Subject: Re: Owner and privileges on sequences
  • Date: Mon, 12 Oct 2009 23:03:41 +0200
  • Message-id: <200910122303.41613.guillaume@lelarge.info> <text/plain>

Le vendredi 9 octobre 2009 à 09:50:22, Dmitry Samokhin a écrit :
> 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 ...;
> ...
> 

I don't quite understand why it should be your way and not the other. Care to 
explain?

Regards.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group