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

8 votes118 views1 answer
Oracle search source code
SQL
1 vote119 views1 answer
Sql delete all values in a column
SQL
0 vote114 views1 answer
Equi joins in oracle
SQL
0 vote162 views1 answer
Mysql readable output
SQL
1 vote128 views1 answer
Sql sort column by date
SQL
3 votes121 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
7 votes117 views1 answer
Minecraft forge server host
SQL
10 votes121 views2 answers
Sql pagination offset
SQL
32 votes134 views6 answers
Rename column mysql
SQL
0 vote110 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL