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 vote239 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote245 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
2 votes182 views3 answers
Postgresql reset auto increment
SQL
5 votes192 views2 answers
Create function postgresql
SQL
0 vote201 views1 answer
Delete a record from a table sqlite3
SQL
0 vote178 views1 answer
Select last 2 characters sql
SQL
0 vote264 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote184 views1 answer
Yesql
SQL
0 vote189 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote214 views1 answer
Wordpress make wp user in db
SQL