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

56 votes661 views5 answers
Psql create user
SQL
0 vote399 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote342 views1 answer
Recursive query herarchical data sql server
SQL
0 vote338 views1 answer
Automate mysql cli query
SQL
0 vote359 views1 answer
Oracle allow space to user
SQL
2 votes428 views1 answer
Drop all foreign key constraints mysql
SQL
11 votes366 views2 answers
Insert date sql
SQL
5 votes369 views4 answers
Select random rows sql
SQL
2 votes345 views1 answer
Mysql time ago difference
SQL
4 votes346 views1 answer
Oracle error compilation line
SQL