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 vote187 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote189 views1 answer
Postgres in operator with comma separated values
SQL
1 vote181 views1 answer
Drop function
SQL
0 vote201 views1 answer
Oracle allow space to user
SQL
3 votes186 views1 answer
Sql server check version
SQL
8 votes176 views1 answer
Unique vs primary key
SQL
4 votes198 views1 answer
T-sql get duplicate rows
SQL
5 votes184 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote205 views2 answers
Insert data mysql with cmd
SQL
3 votes161 views1 answer
Difference sql vs mysql
SQL