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 vote214 views1 answer
Custom row number
SQL
3 votes222 views2 answers
To_char sql
SQL
3 votes212 views2 answers
Sql asc
SQL
14 votes215 views3 answers
Alter foreign key
SQL
8 votes220 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote198 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote151 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote199 views1 answer
Oracle add proxy
SQL
0 vote218 views1 answer
Mysql last friday of current month
SQL
0 vote192 views1 answer
Dasebase_url-postgres for windows
SQL