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 votes141 views1 answer
Oracle sql day of month from date
SQL
1 vote478 views1 answer
Mysql event last execution
SQL
0 vote158 views1 answer
Soql user profile
SQL
5 votes106 views1 answer
Mongodb vs
SQL
7 votes181 views4 answers
Database dump mysql command
SQL
0 vote147 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote157 views1 answer
Oracle sql date summer time
SQL
3 votes103 views4 answers
Show columns from table
SQL
0 vote153 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote146 views1 answer
Grant privileges of databse to user
SQL