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

28 votes100 views6 answers
Sql update
SQL
1 vote59 views1 answer
Athena query timestamp greater than
SQL
-1 vote107 views1 answer
Utf8_encode mysql
SQL
0 vote97 views1 answer
Replace multiple string in query sql
SQL
0 vote102 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote95 views1 answer
Oracle create job if not exists
SQL
1 vote130 views1 answer
How do you use sql in you company
SQL
3 votes100 views1 answer
Oracle sleep
SQL
0 vote94 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
1 vote110 views2 answers
Oracle list partitioned tables
SQL