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 vote262 views4 answers
Mysql on kubernetes
SQL
1 vote259 views1 answer
Copy postgres table from one schema into another
SQL
1 vote248 views1 answer
Sql server reseed single table
SQL
-1 vote272 views1 answer
Default username and password for oracle 11g
SQL
1 vote258 views1 answer
Encrypt password postgresql
SQL
0 vote246 views1 answer
Mysql show foreign keys column
SQL
6 votes302 views5 answers
Oracle list tablespaces
SQL
0 vote262 views1 answer
Connect to nginx server mysql remotly
SQL
2 votes286 views1 answer
Oracle Column Names of a table
SQL
0 vote267 views1 answer
Mysql range of dates overlap
SQL