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|