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

2 votes122 views2 answers
How to add not null constraint in sql
SQL
1 vote126 views1 answer
Update mysql centos
SQL
1 vote116 views2 answers
Update with inner join sql server
SQL
0 vote121 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote118 views1 answer
Mysql drop vs delete
SQL
0 vote108 views1 answer
Mysql update sequence with order by
SQL
3 votes117 views1 answer
Oracle apex call duration
SQL
5 votes114 views1 answer
Mysql add user with all privileges
SQL
0 vote116 views1 answer
Backup a table in sql
SQL
0 vote108 views1 answer
Hibernate with springboot mysql
SQL