GRANT SELECT privilege to ALL sequences using one statement
The accepted answer dont worked for me on 9.1. The below sentence did work:
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO user;
In PostgreSQL 9.x, you can grant permissions on all sequences in one schema to a role. The syntax is
GRANT SELECT
ON ALL SEQUENCES IN SCHEMA schema_name
TO role_name
The role can be either a group role or a login role (user name).
This will be very useful in the future:
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;