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

2 votes143 views1 answer
Oracle log files
SQL
0 vote103 views1 answer
Sql server select value large text
SQL
0 vote101 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote95 views1 answer
Stuff in sql server
SQL
48 votes168 views3 answers
Psql create database
SQL
0 vote113 views1 answer
Alter rename command in mysql
SQL
3 votes107 views3 answers
Stop mysql service ubuntu
SQL
1 vote104 views1 answer
STOP message of how many rows affected sql
SQL
1 vote112 views1 answer
Mysql decimal allow negative values?
SQL
0 vote108 views1 answer
Sql mod even odd
SQL