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 vote238 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
3 votes185 views1 answer
Oracle list privileges
SQL
0 vote140 views1 answer
Postgres delete where id in
SQL
0 vote172 views1 answer
Mysql in clausule string array
SQL
1 vote162 views1 answer
How to delete data from sql database in android
SQL
0 vote164 views1 answer
Calculate date and convert to yearsmysql
SQL
2 votes198 views3 answers
Postgres json to string
SQL
3 votes177 views1 answer
Oracle undo tablespace list by user
SQL
0 vote153 views1 answer
QCompleter con sql
SQL
0 vote164 views1 answer
Truncate table sql server foreign key
SQL