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;

Tags:

Sql

Postgresql