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 vote210 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
-1 vote197 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote159 views1 answer
Sql select rows with simlar names
SQL
1 vote257 views1 answer
Pgsql sum switch case
SQL
1 vote176 views1 answer
Sql delete row with auto increment
SQL
0 vote200 views1 answer
Geopoint from json mysql function
SQL
0 vote183 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote243 views1 answer
CONVERT time string into 12 hours in sql
SQL
8 votes270 views1 answer
Oracle search code in packages
SQL
0 vote189 views1 answer
Transaction database with php
SQL