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

8 votes356 views3 answers
Connect python to mysql
SQL
1 vote362 views1 answer
Mysql strict_trans_tables
SQL
1 vote376 views1 answer
Sql select whole row max column
SQL
0 vote337 views1 answer
Postgresql alter column nullable
SQL
0 vote382 views1 answer
SQL: calculate hours from two dates
SQL
2 votes330 views1 answer
Oracle cpu per session
SQL
0 vote343 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
0 vote358 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote338 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
8 votes362 views1 answer
Today minus 15 days postgresql
SQL