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 vote334 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
1 vote319 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote316 views1 answer
Sql delete dastabase
SQL
9 votes327 views1 answer
Sql server get utc date
SQL
17 votes341 views4 answers
Postgres list users
SQL
0 vote313 views1 answer
Mysql_error replacement
SQL
0 vote345 views1 answer
Limit in access query
SQL
0 vote347 views3 answers
Run sql command line
SQL
16 votes331 views3 answers
Tsql rename column name
SQL
0 vote346 views1 answer
Wordpress delete post revisions older than date "sql"
SQL