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 vote205 views1 answer
Sql select min row
SQL
2 votes236 views2 answers
Oracle create table if not exists
SQL
123 votes338 views5 answers
Sql where contains
SQL
21 votes220 views4 answers
Oracle add column
SQL
0 vote239 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
5 votes218 views1 answer
AND OR NOT operators sql
SQL
0 vote241 views2 answers
Temp Space
SQL
0 vote243 views1 answer
Check if a column is a primary key in sql server
SQL
4 votes222 views2 answers
SELECT table_name FROM user_tables;
SQL
92 votes361 views6 answers
Substring
SQL