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

3 votes173 views1 answer
Sql case update
SQL
0 vote183 views1 answer
Mysql récupérer le code création de vue
SQL
3 votes191 views2 answers
Sql end of month
SQL
0 vote184 views1 answer
Sql examples from framework
SQL
4 votes181 views2 answers
Show all database inside postgresql
SQL
1 vote157 views1 answer
Firebase bigquery cloud message
SQL
1 vote120 views1 answer
Postgres reset auto increment
SQL
3 votes169 views1 answer
Mysql load sql from file
SQL
0 vote173 views1 answer
How to login to mysql in homestead
SQL
3 votes315 views9 answers
Linq to sql converter online
SQL