错误:使用Postgres的sequence cities_id_seq权限被拒绝
错误:使用Postgres的sequence cities_id_seq权限被拒绝
提问于 2012-02-17 16:24:32
我是postgres的新手(以及所有数据库信息系统的新手)。我在我的数据库上运行了以下sql脚本：
create table cities (
id serial primary key,
name text not null
);
create table reports (
id serial primary key,
cityid integer not null references cities(id),
reportdate date not null,
reporttext text not null
);
create user www with password 'www';
grant select on cities to www;
grant insert on cities to www;
grant delete on cities to www;
grant select on reports to www;
grant insert on reports to www;
grant delete on reports to www;
grant select on cities_id_seq to www;
grant insert on cities_id_seq to www;
grant delete on cities_id_seq to www;
grant select on reports_id_seq to www;
grant insert on reports_id_seq to www;
grant delete on reports_id_seq to www;当用户www尝试执行以下操作时：
insert into cities (name) values ('London');我得到以下错误：
ERROR: permission denied for sequence cities_id_seq我知道问题出在序列类型上。这就是为什么我将*_id_seq的select、insert和delete权限授予www。然而，这并没有解决我的问题。我遗漏了什么？
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/9325017
复制相关文章
相似问题