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

1 vote199 views1 answer
Increase existing date in sql oracle
SQL
-1 vote195 views1 answer
Mysql case when multiple conditions
SQL
0 vote190 views2 answers
Sql join on comma separated field
SQL
6 votes208 views2 answers
Postgresql restore from dump
SQL
1 vote204 views1 answer
Snowflake rename column name
SQL
1 vote161 views1 answer
Insert into sql
SQL
1 vote198 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
5 votes204 views1 answer
Oracle sysdate - 1 month
SQL
2 votes176 views1 answer
Merge two columns in sql oracle
SQL
1 vote202 views1 answer
Oracle turn off constraint
SQL