Do postgresql

DO $$DECLARE r record;
BEGIN
    FOR r IN SELECT table_schema, table_name FROM information_schema.tables
             WHERE table_type = 'VIEW' AND table_schema = 'public'
    LOOP
        EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser';
    END LOOP;
END$$;

Source: postgresql.org

Similar codes

0 vote160 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
1 vote179 views1 answer
Mysql view current queries
SQL
9 votes186 views5 answers
Sql limit
SQL
3 votes187 views1 answer
Oracle revoke grant
SQL
14 votes197 views6 answers
Auto_increment mysql
SQL
8 votes206 views1 answer
Racle create auto increment column
SQL
0 vote189 views1 answer
Php mysqli install
SQL
2 votes194 views1 answer
Dbms transaction (psql)
SQL
0 vote186 views1 answer
Alter column to not null with default value sql server
SQL
0 vote187 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL