GRANT SELECT privilege to ALL sequences using one statement

Question

How can I grant the SELECT privilege on all sequences to a user using one statement? Somthing like:

GRANT SELECT ON <ALL SEQUENCES???> TO myUser

Answer 1

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).

Answer 2

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; 

Answer 3

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;