Hello,

CREATE TABLE foo (id bigserial primary key, fname text);
GRANT INSERT ON foo to jd;
INSERT INTO foo(fname) VALUES ('Joshua');

This will fail, because I don't have permissions on the sequence 
foo_id_seq which is a dependency created
by PostgreSQL. It seems that if bigserial is the datatype the grant 
should automatically cascade.

This behavior would make sense if I did it the long way, where I used 
bigint and then modified the column
with ALTER TABLE after the fact.

Joshua D. Drake

pgsql-hackers by date

Next:	From: Greg Stark	Date: 2005-12-02 06:40:06
	Subject: Re: Fork-based version of pgbench
Previous:	From: Joshua D. Drake	Date: 2005-12-02 05:04:18
	Subject: Weird Grant/Revoke/Usage behavior