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

5 votes149 views1 answer
Mysql last day of next month
SQL
16 votes128 views4 answers
Sort by sql
SQL
2 votes130 views1 answer
Oracle sql concatenate results into string
SQL
1 vote157 views3 answers
Sql procedure
SQL
0 vote168 views1 answer
Mysql get hour from datetime
SQL
1 vote139 views1 answer
OstgreSQL version
SQL
19 votes136 views6 answers
Laravel sql query
SQL
0 vote191 views1 answer
Get statis values sql
SQL
0 vote152 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote136 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL