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 vote317 views1 answer
Plsql trigger insert update
SQL
0 vote335 views1 answer
Psql no such file or directory
SQL
7 votes381 views1 answer
Xampp reset mysql
SQL
1 vote381 views1 answer
Database Queries
SQL
0 vote348 views1 answer
Sql remove last 2 digit
SQL
16 votes328 views2 answers
Gremove folder from git
SQL
5 votes375 views1 answer
Mysql last day of next month
SQL
1 vote356 views1 answer
DATE_SUB postgres
SQL
0 vote384 views1 answer
Postgres dump sql insert
SQL
0 vote395 views1 answer
Insert query return id mysql
SQL