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 vote145 views1 answer
Database xml sql
SQL
2 votes149 views1 answer
Get hour from date sql
SQL
0 vote109 views1 answer
Update set with join pl sql
SQL
0 vote140 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
1 vote161 views2 answers
Check if word is in column sql
SQL
0 vote169 views2 answers
PostgreSQL having
SQL
0 vote190 views1 answer
Insert into table with only identity column
SQL
1 vote151 views2 answers
Snowflake alter column data type
SQL
0 vote133 views1 answer
Running query in redshift
SQL
0 vote157 views1 answer
What is database username and password in mysqliconnect
SQL