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 vote167 views2 answers
Sql unique
SQL
0 vote148 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote135 views1 answer
Oracle allow space to user
SQL
11 votes139 views2 answers
How to import mysql database command line
SQL
0 vote145 views1 answer
Microsoft sql server python connection
SQL
0 vote137 views1 answer
Insert into select with group by
SQL
2 votes139 views1 answer
Add new column not null sql server
SQL
28 votes128 views6 answers
Sql update
SQL
11 votes82 views1 answer
Reset identity sql server
SQL
0 vote121 views3 answers
ChAnge TABLE name apex oracle
SQL