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 vote181 views1 answer
Limiting query result using where in sql
SQL
1 vote202 views1 answer
Select not matching data from two tables
SQL
5 votes225 views1 answer
Oracle get ddl
SQL
0 vote201 views1 answer
Postgresql delete multiple rows
SQL
0 vote242 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote221 views1 answer
Create new index takes long time postgresql
SQL
0 vote238 views1 answer
Gcloud sql instance list
SQL
0 vote204 views2 answers
Sql join on comma separated field
SQL
0 vote193 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote989 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL