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 vote234 views1 answer
Mysql delete from where like
SQL
6 votes202 views2 answers
Mysql first day of month
SQL
2 votes243 views1 answer
Sql compare strings
SQL
-1 vote214 views1 answer
How to open blade file from blade in laravel
SQL
1 vote194 views1 answer
Get url of cpanel database hostname
SQL
0 vote253 views2 answers
Search stored procedures
SQL
0 vote220 views1 answer
Mysql min value row
SQL
5 votes198 views5 answers
Sqlite install python
SQL
0 vote183 views1 answer
Mariadb set vertical output format
SQL
0 vote195 views1 answer
Mysql add comment to column
SQL