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 vote153 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
19 votes156 views6 answers
Sql drop table if exists
SQL
0 vote213 views1 answer
Regex mongoose
SQL
1 vote327 views2 answers
Sql unique rows
SQL
0 vote181 views1 answer
Check constraint is violated
SQL
-1 vote148 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote165 views1 answer
Postgresql array to rows
SQL
3 votes168 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
7 votes177 views1 answer
Mysql unsafe update
SQL
1 vote167 views1 answer
Table valued functions in sql
SQL