在PostgreSQL 9.x中，您可以将一个模式中所有序列的权限授予一个角色。syntax是

GRANT SELECT
ON ALL SEQUENCES IN SCHEMA schema_name
    TO role_name

字符串
角色可以是组角色或登录角色（用户名）。

这在将来会非常有用：

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO your_user;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA schema_name TO your_user;
GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA schema_name TO your_user;

字符串

接受的答案对我不起作用9.1。下面的句子起作用了：

GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO user;

字符串

在Postgres 13中运行

GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO admin;

字符串

对于Postgres版本低于9.0

psql -d DBNAME -qAt -c "SELECT 'GRANT SELECT ON ' || relname || ' TO USER;' FROM pg_statio_all_sequences WHERE schemaname = 'public'" | psql -d DBNAME

字符串
参考：http://gotochriswest.com/blog/2012/06/11/postgresql-granting-access-to-all-sequences/

在Postgres 15+中，有预定义的角色，可以在设置数据库时更容易地授予有用的权限。
参见https://www.postgresql.org/docs/current/predefined-roles.html

GRANT pg_read_all_data TO USER;  
-- SELECT on all tables, views, and sequences. USAGE of all schemas.

GRANT pg_write_all_data TO USER;
-- INSERT, UPDATE, DELETE on all tables, views, and sequences. Usage of all schemas.

字符串