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 vote150 views1 answer
Sql server set variable if exists
SQL
1 vote115 views1 answer
How to delete record sql delphi
SQL
1 vote123 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote124 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
3 votes121 views2 answers
Postgresql remove not null constraint
SQL
2 votes128 views2 answers
How to add not null constraint in sql
SQL
0 vote126 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote122 views1 answer
Create table if not exist with exceptions
SQL
1 vote150 views2 answers
Oracle 18c xe ORA-65096
SQL
1 vote122 views1 answer
Spring postgresql reset auto increment to 0
SQL