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 vote234 views1 answer
Oracle sql generate list of days
SQL
0 vote251 views1 answer
Sql alchemy escape ; in insert statement
SQL
24 votes264 views4 answers
Postgres delete database
SQL
0 vote225 views1 answer
Oracle search in date columns
SQL
0 vote223 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote243 views2 answers
Sqlalchemy core in clause
SQL
8 votes245 views5 answers
Grant permission in postgres
SQL
13 votes236 views5 answers
Select last row mysql
SQL
0 vote233 views1 answer
Mysql repair a table
SQL
0 vote239 views1 answer
Db format in quotation
SQL