From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Additional Grant/revoke problem |
Date: | 2005-12-02 05:19:10 |
Message-ID: | 438FD94E.7010807@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2005-12-02 06:40:06 | Re: Fork-based version of pgbench |
Previous Message | Joshua D. Drake | 2005-12-02 05:04:18 | Weird Grant/Revoke/Usage behavior |