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 vote296 views1 answer
Allow null in psql
SQL
1 vote289 views1 answer
Age postgres
SQL
0 vote263 views1 answer
Java input type sql date
SQL
7 votes289 views3 answers
Sql server reset auto increment
SQL
0 vote262 views1 answer
Django mysqlclient connection string
SQL
0 vote262 views1 answer
Oracle search in date columns
SQL
1 vote279 views1 answer
Wordpress change url phpmyadmin
SQL
6 votes271 views2 answers
Mysql check auto increment value
SQL
0 vote296 views1 answer
Set column in all row mysql
SQL
0 vote270 views1 answer
Find number of entries sql
SQL