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

5 votes129 views3 answers
Db begintransaction laravel
SQL
0 vote109 views4 answers
Mysql replace regex
SQL
0 vote100 views2 answers
Postgresql create role
SQL
0 vote98 views1 answer
Mysql money value
SQL
0 vote160 views1 answer
How to compile a function in oracle
SQL
6 votes100 views6 answers
Count mysql
SQL
1 vote128 views2 answers
Remove space in mysql
SQL
0 vote106 views1 answer
Get all employees if name ends with in sql
SQL
0 vote129 views1 answer
Sql server create constraint
SQL
0 vote121 views1 answer
How to inner join 4 tables in sql
SQL