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

9 votes142 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote147 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote128 views1 answer
Sql server get date of previous sunday
SQL
1 vote125 views1 answer
T-sql find object by name
SQL
0 vote145 views1 answer
Sql server python connection
SQL
0 vote151 views1 answer
Check if a column is a primary key in sql server
SQL
1 vote98 views1 answer
Unique vs distinct sql
SQL
0 vote130 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote132 views1 answer
Sum sqlserver
SQL
0 vote124 views1 answer
Mysql with
SQL