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 vote231 views1 answer
VSCode SQL Server Connection error
SQL
1 vote239 views1 answer
Sql count value greater than
SQL
19 votes236 views5 answers
Mysql between date range
SQL
1 vote233 views1 answer
Query for all indexes in table postgres
SQL
0 vote237 views1 answer
Str_to_date sql server
SQL
0 vote230 views1 answer
Sqlite get date only
SQL
0 vote229 views1 answer
Import big data to mysql
SQL
0 vote240 views1 answer
Sql tablo hangi sp de
SQL
1 vote226 views2 answers
Change table name phpmyadmin
SQL
0 vote213 views1 answer
Select from 3 tables one is empty
SQL